Data aggregation with 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.
--
Kad

Data aggregation with multiple workbooks
 

On May 10, 2:39*pm, Kadco wrote:
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.
--
Kad

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.