excel simple prob w/running subtotals
 

i'm not very well versed in excel and hoping this is a simple problem:

making a cost report and i need to emulate various colums that loo
like this:

ACTUAL THIS WEEK ACTUAL TO DATE
600 81,000
3,500 32,000
100 53,000

SUBTOTAL

4200 166,000

the "TO DATE" column is a running total of values spent, so would
need a separate sheet for every week, or is there a way i can save th
values from the "THIS WEEK" column in a variable or to an externa
file?

any advice is much appreciated - thanks

--
Message posted from http://www.ExcelForum.com

excel simple prob w/running subtotals
 

sorry, messed up the formatting....

the columns a

ACTUAL THIS WEEK
600
3,500
100

ACTUAL TO DATE
81,000
32,000
53,000

and then the SUBTOTALS of each column.. sorry if this confuse

--
Message posted from http://www.ExcelForum.com