PDA

View Full Version : Cell Reference in another excel file



SureshSuresh
04-05-2007, 12:05 AM
Hi!
I want to give one cell reference in another excel work book, is it possible?
How can I do this? Help me!
Thanks in advance!

Simon Lloyd
04-05-2007, 01:28 AM
if you open two workbooks and enter this in A1 of Book1 =[Book2]Sheet1!$A$1 then whatever appears in A1 Book2 will apear in Book1 A1

Regards,
Simon

SureshSuresh
04-07-2007, 02:34 AM
Thankyou very much, Simon! I succeeded in doing that, it is too helpful to me!