Excel Formula

[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?

 

[Luke M]

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.