S
ScottS
I have a large spreadsheet with each tab organized as a table, each table has
a dynamic named range.
My users want to access data from this main source by selecting a range name
from a list (cell with dropdown list). I have been able to get this to work
in one workbook by using INDIRECT to capture the range name and INDEX\MATCH
to bring in the actual cell contents.
When I try to do this with INDIRECT I get the REF# error. Is this something
that can be done?
Thanks in advance for any help or suggestions.
a dynamic named range.
My users want to access data from this main source by selecting a range name
from a list (cell with dropdown list). I have been able to get this to work
in one workbook by using INDIRECT to capture the range name and INDEX\MATCH
to bring in the actual cell contents.
When I try to do this with INDIRECT I get the REF# error. Is this something
that can be done?
Thanks in advance for any help or suggestions.