Data aggregation with multiple workbooks

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.
 
T

Trekman

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aggregating data among multiple workbooks 1
Multiple Worksheets 6
Merge Multiple workbook sheets into one workbook 0
consolidate workbooks to worksheets in one workbook? 1
Editing Data in Multiple Worksheets/Workbooks 1
two way workbooks 2
multiple workbooks in one file 3
Multiple workbooks to one worksheet 3

Top