| 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! |
| 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) | |||
Threaded Mode
