Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining worksheets
I have 7 worksheets that are laid out identical for fields, etc. I would
like to have a single summary worksheet that automatically updates when cells are changed in the other worksheets. This is a very simple worksheet and I'm pretty sure there is a way to do this simply. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining worksheets
Hi Terry, Assuming as you said all the 7 worksheets are identical, create another Summary worksheet with the headers and let's say your data starts in A2 in all the worksheets, in cell A2 enter the formula as follow =SUM(Sheet2:Sheet7!A2) then copy the formula across your summary sheet Replace sheet2 and sheet7 with the name of the first and last worksheets in your workbook If this was helpful please click yes "Terry Sharman" wrote: I have 7 worksheets that are laid out identical for fields, etc. I would like to have a single summary worksheet that automatically updates when cells are changed in the other worksheets. This is a very simple worksheet and I'm pretty sure there is a way to do this simply. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining worksheets | Excel Worksheet Functions | |||
Combining Worksheets | Excel Worksheet Functions | |||
Combining Worksheets into one | Excel Worksheet Functions | |||
Combining 2 or more worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions |