Purchase Order/Invoice ledger

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.

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

"Speaker" wrote:

> 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.