View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Hodgson John Hodgson is offline
external usenet poster
 
Posts: 2
Default linking workbooks



"Kaby" wrote:

How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

HI, i'm not to sure what you are asking, if you wish to display a value in one cell that is on another worksheet or work book you just need to type = in the formula box and then navigate to the cell you wish to link, then press enter.


If you want to link to a file or folder you need to use a hyperlink. The
important thing to remember with this is that if you are emailing the file
this link will be broken if the recipient does not have the file saved
locally in the same place, of if it is not shared on a network.