| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple worksheets - getting data from same cell for a list
Hi - Could anyone assist please.
I have a workbook (just the one document) with around 60 pages of active data in it - all pages have the same format. Just the data (scores in this case) and page name (page1, page2 etc.) change. I am trying to do a master list on the front page which pulls the data from cell G192 from each page onto a master refrence list. Is there anyway to bring the contents to the master list other than write in cell A1 = Book1!G192 in cell A2 = Book2!G192 etc.,? I can do this 60 times but there must be a simpler way. Anyone got any tips please? Ta Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Simple List...Multiple Columns and Multiple Worksheets | Excel Worksheet Functions | |||
| Multiple Worksheets and Cell References - Data Output | Excel Discussion (Misc queries) | |||
| Compile list of same cell from multiple worksheets | Excel Worksheet Functions | |||
| list data of same cell on different worksheets. | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Threaded Mode
