| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize data from multiple sheets
G'day! My first sheet is a summary sheet. All the subsequent sheets are
identically designed data entry sheets, BUT the sheet names are random (not sequential) AND the names and total number of subsequent data entry sheets are unknown as additional data entry sheets can be added (and renamed) at any time. How can I automatically (either by way of formula or macro or other) reference data from the first data entry sheet into cells in Row-1 of the summary sheet and then reference the same data from the next data entry sheet into cells in Row-2 of the summary sheet... continuing until the last sheet? Merry Christmas! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIF to summarize amount in different sheets by date | Excel Worksheet Functions | |||
| What function do I use to summarize data levels on three sheets? | Excel Worksheet Functions | |||
| summarize data from multiple worksheets | Excel Discussion (Misc queries) | |||
| Charting series in different sheets (summarize) | Charts and Charting in Excel | |||
| Summarize data with multiple conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
