Now let's discuss how to use Excel to reference a cell in another worksheet based on cell value Reference cells in another Excel worksheet based on cell value I will show two examples here Example 1 Select a single cell and refer a whole range of cells I have two Excel worksheets with names BATBC and GP You can have many Figure 7 Result of the Dynamic Worksheet Reference Explanation The INDIRECT function works by evaluating text as a worksheet reference Here, the name of each sheet is joined to the cell reference (A1) using From a closed WKB get a cell Value when we do not know the Sheet Name (23 replies) BHi and thanks in advance!/B Is it possible to get from a closed workbook file a cell value How to reference Sheet name from Cell Value inside a SUMIF excel function Ask Question Asked 3 years, If you're not using VBA then you need an indirect cell reference that will contain a sheet name Eg in cell A1 you have the name "SBI", then the formula would be Excel Autoshape get it's name from cell (value) 1
Macro To Copy Filtered Data Into Multiple Worksheets Excel
