View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
diesel cdg diesel cdg is offline
external usenet poster
 
Posts: 1
Default 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