Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking 2 excel workbooks
Is there any way to link 2 excel workbooks together in a separate workbook?
Every week I export an excel spreadsheet from my business program and store it on a shared drive. Another individual does the same. However we run to different business programs, but the excel spreadsheets are setup the same (4 columns with part numbers, descriptions, qty, and value) and are stored in the same shared drive. I'm wondering if we both stored our spreadsheets on the shared drive they would automatically update into a third spreadsheet that anyone could review. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking 2 excel workbooks
Y es, it can be done.
Assuming your file names and locations do not change... Open both your workbooks and a new workbok In the new workbook click on Sheet1, A1 cell Enter = Click on the workbook you want to link to, then click on the cell you want. In similar ways you can link remaining cells in both the workbooks. "stu7656" wrote: Is there any way to link 2 excel workbooks together in a separate workbook? Every week I export an excel spreadsheet from my business program and store it on a shared drive. Another individual does the same. However we run to different business programs, but the excel spreadsheets are setup the same (4 columns with part numbers, descriptions, qty, and value) and are stored in the same shared drive. I'm wondering if we both stored our spreadsheets on the shared drive they would automatically update into a third spreadsheet that anyone could review. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking workbooks in Excel | Excel Discussion (Misc queries) | |||
Linking excel workbooks | Excel Discussion (Misc queries) | |||
Linking problems between two workbooks - Excel 2000 SP3 | Setting up and Configuration of Excel | |||
Linking workbooks in Excel | New Users to Excel | |||
linking excel workbooks | Excel Worksheet Functions |