| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Named Ranges and Dynamic Formulas
I have a number of tabs with the same Name Range on each tab.
I want reference the named ranges using a value in a cell in another worksheet (same workbook). Example: Summary Tab - A2 = "01", B2 = '01'!NamedRange Summary Tab - A3 = "02", B3 = '02'!NamedRange Except I would like to use a formula that inserts the value from column A to reference that Tab to pull the range from. Something like: = ' & A2 & '!NamedRange Is that possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic charts without Named Ranges? | Charts and Charting in Excel | |||
| can VLOOKUP use dynamic named ranges? | Excel Discussion (Misc queries) | |||
| Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
| Dynamic Named Ranges | Charts and Charting in Excel | |||
| Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
