View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fingerjob Fingerjob is offline
external usenet poster
 
Posts: 26
Default Merging Data from Workbooks

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?