How to Link Data to Another Spreadsheet in Excel
If you need to use several spreadsheet files to keep your data current, try linking cells of one spreadsheet to another. This way you will not have to key the data into several spreadsheets every time you make changes to one item. You can even link a Word file to an Excel file.
Other People Are Reading
Instructions
-
-
1
Open the Excel program in the usual way. Select and open the 2 files you want to link (at the same time).
-
2
Select the cells you want to link in the source document. Changes you make in the source data will automatically update in the destination document.
-
-
3
Go to the formula bar and type the equal sign ("="). Key in the worksheet name and cell addresses you are using for the selected source file cell. An example of this is: "=[EBAY Bookkeeping.xls]Sheet1'!$C$7." What you have here is the equal sign, name of the file, name of the worksheet, and the name of the cells you are importing. The "!" references the cell address that you want to display.
-
4
Realize that this will give you the ability to link the 2 spreadsheets together through the 1 cell. See the Resources section below to pull up a document that shows you how to link data in Word to an Excel worksheet.
-
1
Resources
More Like This
Comments
-
jaggos200
Nov 12, 2008
Over the past week i have been useing 2000 xcell and now want to link eack sheet to each other.My fist sheet has 30 cells on it and each are counts my stock by day for 31 days, with 25 Departments. My next sheet has a total of each cell by weight,usage and cost.With all 25 sheets tied in to the one(sheet 2)My 3 sheet is cost per department.I need to know how to link them! I have try some of the thing Ive seen on line but.I still a fish out of water. I could send it as a email to any one if that would help.. I know im asking a lot. But its a shot in the dark. Joe -
jaggos200
Nov 12, 2008
Over the past week i have been useing 2000 xcell and now want to link eack sheet to each other.My fist sheet has 30 cells on it and each are counts my stock by day for 31 days, with 25 Departments. My next sheet has a total of each cell by weight,usage and cost.With all 25 sheets tied in to the one(sheet 2)My 3 sheet is cost per department.I need to know how to link them! I have try some of the thing Ive seen on line but.I still a fish out of water. I could send it as a email to any one if that would help.. I know im asking a lot. But its a shot in the dark. Joe
