View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Trekman Trekman is offline
external usenet poster
 
Posts: 11
Default 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.