View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh O. Josh O. is offline
external usenet poster
 
Posts: 77
Default 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?