Is importing one Excel spreadsheet into another Excel spreadsheet possible?

Question

Can I import an Excel spreadsheet into another spreadsheet (two separate files) by linking in certain cells from one to show in other cells in a different file?

I'm not sure if I can do this or where I'd go if it possible to make it work. I have no programming background.

Answer 1

Yes:

• Open both workbooks
• Activate the workbook you want automatically updated
• Select a cell you want to link
• Type =
• Activate the other workbook
• Select the cell you want to link and hit "enter"
• You will return to the first workbook and the selected cell will contain the reference e.g. =[FirstFile.xls]Sheet1!$A$11
• Repeat for each cell you want to link

• If you want to, you could include references in formulae, say if you wanted half the value, you would do as above then add /2 to get =[FirstFile.xls]Sheet1!$A$11/2 or maybe multiply the vales of two cells e.g.

  =[FirstFile.xls]Sheet1!$A$11* =[FirstFile.xls]Sheet1!$B$42
  

Answer 2

Copy the cell in your 'source' spreadsheet, then do a 'Paste Special' into your target spreadsheet. This will copy the value and leave a link pointing to the original spreadsheet, so changes in the source will be reflected in the target.