Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing cells in multiple worksheets
I have a file with multiple worksheets (up to 50 in a file). The worksheets
have different names but contain data in the same locations and format as each other. What I want to do is create a table on a worksheet that copies a specific cell from each worksheet that I can then sort. Example: 4 worksheets called: Adam, Dave, Pete, Mike I want to produce a table showing cell B2 from each of the above sheets to look something like: Sheet B2 Value Dave 12 Pete 4 Mike 38 Adam 24 I would like to be able to do this without using a macro if possible. Can anyone help??? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Referencing multiple worksheets | Excel Discussion (Misc queries) | |||
Referencing Cells on Different Worksheets | Excel Worksheet Functions | |||
Macro referencing multiple worksheets | Excel Discussion (Misc queries) | |||
Formula Referencing data on multiple worksheets | Excel Worksheet Functions | |||
Summary worksheet referencing multiple worksheets | Excel Worksheet Functions |