Excel- merging running totals

Laura4191 - Feb 10, 2009 at 07:49 AM
 Helper - Feb 10, 2009 at 06:10 PM
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 response

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]