Hi,
maybe =indirect("'"&A2&'!NamedRange)
Josh O.;292030 Wrote:
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?
--
Pecoflyer
Cheers -
*'Membership is free' (
http://www.thecodecage.com)* & allows file
upload -faster and better answers
*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=81615