Data aggregation with multiple workbooks

  • Thread starter Thread starter Kadco
  • Start date Start date
K

Kadco

I am currently setting up a workbook. In this workbook I have a data input
sheet where people would fill out information. Multiple people will be
filling out this worksheet. What is the best way to aggregate the data among
multiple workbooks.
 
I am currently setting up a workbook. In this workbook I have a data input
sheet where people would fill out information. Multiple people will be
filling out this worksheet. What is the best way to aggregate the data among
multiple workbooks.
Click to expand...

I would say that the best method is to set it up as a shared workbook,
then several can work on it at once and when saved, all comes
together. We use this at work all the time. In Excel 2007 it comes
under the "Review" ribbon of menu choices.
 
Back
Top