Linking Workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create multiple links (ex: an entire column) from one workbook to another in just a few steps?
 
Hi Kim
try
- open both workbooks
- lets say you want to link cells in column A
- in cell A1 on your first workbook enter the equation sign '='
- now activate with your mouse workbook twi and select cell A1 in this
workbook
- hit enter: the formula should look like: ='[book2.xls]Sheet1'!A1
- copy this formula down as far as you need
 
Back
Top