View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default Creating a formula by using data in another file


with the file open just do what you normally do when you refernce cells
just go
=and then go to the workbook with the cell you want to reference
now they are linked


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517337