merging reports
 

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

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

On Sat, 4 Dec 2004 18:05:04 -0800, cheryl
wrote:

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

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?



"Gord Dibben" wrote:

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

On Sat, 4 Dec 2004 18:05:04 -0800, cheryl
wrote:

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

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

"cheryl" wrote in message
...
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?



"Gord Dibben" wrote:

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

On Sat, 4 Dec 2004 18:05:04 -0800, cheryl

wrote:

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

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.


--
Enjoy the blessings of the day.

jerry
"cheryl" wrote in message
...
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!!!!