View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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.