View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Link Cell to cell in different file

1) Open BOTH WB.
2) In cell C3 of WB1 type = [equal sign] with your mouse(!) move to WB2
CLICK on cell C3 and Press Enter.
Micky


"WildWill" wrote:

I have 2 x files, i.e. "1.xls" & "2.xls". I want cell C3 in the file 1.xls to
reflect the data that I have entered in cell C3 of the file 2.xls. How do I
do this?