Put subtotals in a different column

[Glen Cai]

Hi

I'm using a Palm Vx to keep my
travel expense records. The data can be
converted to an Excel document.
I can sort the data by the Expense
Type (Data->Sort) and subtotal them according
to the Expense Type (Data->Subtotals) using the
Excel built in functions. A new row for the subtotal
is insered into to the original Excel document for
each Expense Type. The data of subtotals are added
in the same column of the original data.

Is there a way to put the data of
subtotals in a different column so that I can do grand
total easily? The original Excel document form Palm has
an empty column next to the expense data column.
I guess it is for subtotals.

Thanks so much in advance.

GC

 

[Doug Glancy]

Glen,

Can you just use the Grand Totals that are part of the Subtotals tool - by
checking the "Summary below Data" checkbox?

Doug