Thread: Excel Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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?