How do I link multiple excel documents?
 

I need to link three Excel Documents into a master document that will reflect
the data inputted into the others. as of right now they are all one document
but that allows only one person at a time to enter the data, we need to have
multiple people entering the data.

How do I link multiple excel documents?
 

Let's try for the easy solution first... Are people entering data on
different worksheets, which are then captured on a 'master' sheet via
equations? If so, open the file (make a backup copy first!), click on one of
the input sheet tabs and select Move or Copy, then move the sheet into a New
Workbook. Save the new workbook with an appropriate name. Now go back to
the master sheet and you'll see all the references now incorporate the new
workbook's name. Repeat for each input sheet, moving each into its own file.
If this is NOT the case, please describe what each person is entering, and
what data (exact copy, summary by month, etc) needs to make it to the master
document, and in what form. If you the master is a complete copy of a
variable number of entries, it'll likely require a macro that, when invoked,
opens and copies all the data from each input file into a common master.



"Jill" wrote:

I need to link three Excel Documents into a master document that will reflect
the data inputted into the others. as of right now they are all one document
but that allows only one person at a time to enter the data, we need to have
multiple people entering the data.

How do I link multiple excel documents?
 

Thank you, while the simple step helps, I still have no clue how to run the
equations so that the master sheet will pull the data from the other files,
the data that is places on the input sheets needs to be an exact copy of the
input data.

"bpeltzer" wrote:

Let's try for the easy solution first... Are people entering data on
different worksheets, which are then captured on a 'master' sheet via
equations? If so, open the file (make a backup copy first!), click on one of
the input sheet tabs and select Move or Copy, then move the sheet into a New
Workbook. Save the new workbook with an appropriate name. Now go back to
the master sheet and you'll see all the references now incorporate the new
workbook's name. Repeat for each input sheet, moving each into its own file.
If this is NOT the case, please describe what each person is entering, and
what data (exact copy, summary by month, etc) needs to make it to the master
document, and in what form. If you the master is a complete copy of a
variable number of entries, it'll likely require a macro that, when invoked,
opens and copies all the data from each input file into a common master.



"Jill" wrote:

I need to link three Excel Documents into a master document that will reflect
the data inputted into the others. as of right now they are all one document
but that allows only one person at a time to enter the data, we need to have
multiple people entering the data.