merging reports

[Guest]

i have been using excel all year to report my expenses.
is there a way to take all the reports and merge them into one to get my
years total?
I am really inept at excell... and will be takign a course in the new year.
i jsut think this would be so much easier than printing off all my reports
and ading them up manually. HELP!!!!

 

[Gord Dibben]

cheryl

I think you must provide more details.

How are your reports laid out? One worksheet? More than one workshhet?

In columns? In rows?

A sample of your lay-out would be helpful.

Gord Dibben Excel MVP

 

[Guest]

one worksheet . columns and rows. it totals automatically for each type of
expenses.. ie postage, meals, etc..

each report has all the same items and functions. i just use the master
copy over and over.
how could i send you an example?
would a pivot table do this for me?

 

[Alok Joshi]

Hi,
One would need more information than this.. The detail would typically go
like this
Each expense report is on one row. The Columns B,C,D and E contain different
categories of expenses. Column V contains the total expense for each expens
report ... etc..etc..
Alok

 

[Gerald Evans]

Cheryl, I have done this with my expense report...before I retired. With
time on my hands I would be glad to see what I can do with yours if you will
send me the master page layout that you are using.

(e-mail address removed)