I have an excel workbook that will be distributed without any data to
multiple parties. After the various parties have entered their data (all of
which are dollar figures), the workbooks will be submitted via email back to
me. All of the workbooks will be formatted exactly the same and contain the
same layout.

My question: is there a way to merge the data in these workbooks to create
a summary of all the data on a new worksheet?

Yes, it is.

Somebody else have to tell you how to do it, i am too lazy now.
So hot in my office now....

Best
Petter

Bryan Potter skrev:

I have an excel workbook that will be distributed without any data to
multiple parties. After the various parties have entered their data (all of
which are dollar figures), the workbooks will be submitted via email back to
me. All of the workbooks will be formatted exactly the same and contain the
same layout.

My question: is there a way to merge the data in these workbooks to create
a summary of all the data on a new worksheet?

Assuming that the spreadsheet will not be amended other than to add values-
Open all the spreadsheets
Copy data from the column of each incoming spreadsheet to adjacent columns
in your 'master' spreadsheet
In the last column add the formula
=sum(b3:z3)
(obviously that will have to be tailored to the data input columns

Regards.

Bill Ridgeway
Computer Solutions

"Bryan Potter" wrote in message
...
I have an excel workbook that will be distributed without any data to
multiple parties. After the various parties have entered their data (all
of
which are dollar figures), the workbooks will be submitted via email back
to
me. All of the workbooks will be formatted exactly the same and contain
the
same layout.

My question: is there a way to merge the data in these workbooks to
create
a summary of all the data on a new worksheet?