Excel Formula
 

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?

Excel Formula
 

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.
--
Best Regards,

Luke M


"Joe" wrote:

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?