Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect alternatives
Using XL 2007 with 2003 compatibility
The below equation works - but are there better alternatives? =INDIRECT(Model_info!$E$25&"!R"&ROW()&"C"&COLUMN() ,FALSE) There are several sheets that are date driven, that the format is the same but the numbers on the sheets are different. The "assumptions" sheet then is used to run the model. The date entered by the user will determine which sheet to grab the values from. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect alternatives
have you not read the replies to yesterday's postings?
-- Regards Roger Govier "Brad" wrote in message ... Using XL 2007 with 2003 compatibility The below equation works - but are there better alternatives? =INDIRECT(Model_info!$E$25&"!R"&ROW()&"C"&COLUMN() ,FALSE) There are several sheets that are date driven, that the format is the same but the numbers on the sheets are different. The "assumptions" sheet then is used to run the model. The date entered by the user will determine which sheet to grab the values from. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect alternatives | Excel Discussion (Misc queries) | |||
Indirect Alternatives | Excel Discussion (Misc queries) | |||
Indirect alternatives | Excel Discussion (Misc queries) | |||
Indirect Alternatives | Excel Worksheet Functions | |||
What are the alternatives ??? | Excel Discussion (Misc queries) |