Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate data from multiple worksheets into one
I have a workbook with multiple worksheets representing different
departments. The colum headings are exactly the same for each department. I want to create a main worksheet that includes all data from these different worksheets, however, this is a "live" workbook that will have new data entered on a consistant basis. Is it possible to have a worksheet that is autopopulated with the new data as it is entered to the other worksheets?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to consolidate multiple worksheets into one. | Excel Discussion (Misc queries) | |||
Consolidate multiple worksheets in a workbook into one | Excel Discussion (Misc queries) | |||
'Consolidate' data from multiple worksheets | Excel Discussion (Misc queries) | |||
How to consolidate data from multiple worksheets. | Excel Worksheet Functions | |||
Consolidate list from multiple worksheets | Excel Worksheet Functions |