There are times when you may use one spreadsheet, or workbook, to pull together data from other spreadsheets.
To link sheets in the same workbook:
Click into the destination cell, type = (an equals sign) then go to the other sheet and click into the cell that contains the information you want (the donor cell), and hit enter. (It makes sense to give each sheet a name before doing this.)
To link sheets in different workbooks (or Excel files):
Have both workbooks (files) open; click into the destination cell, type = (an equals sign) then go to the other workbook (file) click into the cell that contains the information you want and hit enter.
This is described below using some screenshots to illustrate.
A sheet for each day of the week
An Excel Workbook (or file) has more than one sheet. In this picture I have set up sheets to record what I spend on each day of the week.
Week summary sheet
My final sheet pulls together the total for each day.
Linking to another sheet
To get the total for each day, I have linked back to the sheet for each day.
Cell B9 in this sheet, links to Monday’s sheet by the command =Monday!C14 as you can see from looking in the command line box. The cell C14 in sheet Monday contains the total for Monday, and now I have pulled that in to my week summary. To do this, I clicked on cell B9 of Week, typed = then went to the Monday sheet, clicked into cell C14 and hit enter.
There is also another workbook (file) which pulls the weekly totals into a monthly summary.
Link to a different workbook
In this case, the command line contains the full path to the workbook (file) containing the donor cell and the data of interest: =’C:\Users\Mail\Documents\[pastelink.xlsx]Week’!$F$13