Purchase Order/Invoice ledger

[Speaker]

What I would like to do is to keep track of everything that we purchase over
12 months. I have already partly designed the worksheet with 5 fields, the
last two being Purchase Order cost and Invoice cost. I have totalled both
columns.
I would like to have a running total which would export onto the next sheet
and below that the current months total which would be added to the prevoius
months total.

 

[patrick]

you may try a pivot table of the data set. Data>pivot table and charts or
subtotals also under Data menu. Either of these should give you what you
want.
Pat