Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect reference to another worksheet in file
I have a workbook of 20 metropolitan markets located on separate worksheets.
There is also a summary sheet with those same 20 markets listed in a column. What I'd like to do is use the INDEX funtion to bring in indenical data from each market worksheet. I am very familiar with INDEX, so I know that part works. I can't seem to figure out how to use the markets listed on the summary page to change the reference the individual market worksheets that match. I believe I should use the INDIRECT function, but so far I haven't been successful. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect reference to another worksheet in file
I personally dont like INDIRECT (volatile, inefficient etc).
Why dont you try CHOOSE instead? regards Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "MLP" wrote in message ... I have a workbook of 20 metropolitan markets located on separate worksheets. There is also a summary sheet with those same 20 markets listed in a column. What I'd like to do is use the INDEX funtion to bring in indenical data from each market worksheet. I am very familiar with INDEX, so I know that part works. I can't seem to figure out how to use the markets listed on the summary page to change the reference the individual market worksheets that match. I believe I should use the INDIRECT function, but so far I haven't been successful. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On a DDE Linked worksheet : Copy and Paste Value to a to a file via a macro ? | Links and Linking in Excel | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) |