Excel- merging running totals

 Helper -
Hi there!

First, I need to know if what I want to do is even possible. I have about 10 excel sheets- each with two running totals on them. My boss wants me to merge the totals from each document into one master copy, where on that master copy there will be the totals from each sheet. However, he wants this master copy to be automatically updated when he alters the total on one of the original sheets, Is this possible? If so, any advice?

Thank you!!!!

1 reply

Here is a file you can look at to see if this is something like you need.
There are sheets 1,2,3 with daily totals. Then there is summary sheet with totals from the three sheets
on it. Maybe too simple than what you are looking for.

[URL=http://www.4shared.com/file/87064451/4ae3a9b6/Summary_Sheet.html]Summary Sheet.xls[/URL]