Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarising multiple worksheets onto one sheet
Please forgive me as I'm rather unfamiliar with Excel jargon. I'm using Excel
2003 and would like some help on how to summarise multiple worksheets onto one master sheet within the same workbook. Basically the workbook I'm trying to create will have a separate sheet for each division of the department where I work, outlining project work for that division. The data will be purely text. Although the content will vary for each sheet, the headings will be the same. I would like the information from each sheet to automatically and continuously be copied over to a master sheet (ideally Sheet1) so that project work across all divisions can be viewed altogether on demand. Ideally, once this has been set up, if the master sheet were to be updated, the relevant cell on the respective divisional sheet would be updated as well, and vice versa. Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I tie multiple worksheets to one sheet in Excel? | Excel Worksheet Functions | |||
Collating/ Summarising worksheets | Excel Discussion (Misc queries) | |||
Consolidate multiple worksheets into new sheet | Excel Worksheet Functions | |||
Summarising Numerous Worksheets | Excel Discussion (Misc queries) | |||
Summary sheet for multiple worksheets | Excel Discussion (Misc queries) |