Excel Formula

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have two workbooks,, and i would like to link text from one to another. So
when i enter a name on one workbook, the name is linked to the other?

Any suggestions?
 
To link to My Workbook, sheet My Sheet, cell a1:

='[My Workbook.xls]My Sheet'!a1

You can also do this easily by typing "=" in a cell and then clicking the
cell in the other workbook you want to link to.
 
Back
Top