Hi
I hope some one can help me with this
I have a spreadsheet with monthly work worksheets named Apr07, May07, June
07 for the months of the year all the way through to Mar 08
with the following columns

Date Customer Name Sales
Company A 100
Company B 200
Company C 200
Company B 200
Company A 200
Company A 200

What I would like to do is have a running total on the monthly sheet of how
much each company has paid us this month

Giving this layout Company A Total = 500
Company B Total = 400
Company C Total = 200

Then I wish to create a new worksheet called yearly totals and bring each
company monthly total from each company
giving me a total that company A, Company B, Company C has paid this year
so far.

Many thanks for your help

John