Are all the customers in the same workbook or are they all separate
files?

You can run a total at the top of each sheet. Then create a total sheet
with each customer on it. In the box next to there name feed the total
form the individual sheet. That part is simple it's just = and then
click the total box on that individual sheet.

I hope that is what you are looking for. If not I'll try again.


--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=529269