Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) |