Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a "real data" worksheet (Table1) that is populated automatically using
Template Wizard with Data Tracking. I want to keep that data intact. I have an identically structured worksheet (TestData) that I want to be able to muck around with to test formulas. I have a bunch of formulas in various other worksheets that use Names that currently refer to ranges in TestData. I would like to be able to toggle those names to refer to either Table1 or Test Data (same range in either sheet). I've tried 2 approaches that work: - Using the INDIRECT function to construct References based on a worksheet name typed into a cell - Putting the 2 worksheets in separate workbooks (same sheet name in each) and using Edit Links to switch between the two. However, with both of these approaches, the Name does not show up in the Name Box -- definitely an inconvenience! Is there any way I can have my cake and eat it too? (i.e., be able to toggle worksheet in reference AND have Name show up in Name Box)? Thanks. ps -- I'm a neophyte with VBA and macros. Solution requiring neither is preferred, though I will venture forth if necessary! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identifying single column within named range | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions | |||
How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Address of named range | Excel Worksheet Functions |