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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Link changes in destination workbook 4
Excel Protection 2
How to copy Formatting Attributes from Source Workbook when Linkin 3
Updating Workbooks from multiple links Workbooks 1
Linking a workbook to worksheets 1
Link To File That No Longer Exists 1
want to create a link to another worksheet in another workbook 1

Back
Top