Hi Kanmi,

You should use the first approach, which you have written. This is known as
linking of the cells between worksheet tabs. Whenever you open
"Destination.xls", it will ask you to "Update values" and you need to click
on "Ok". This will fetch the data of "Source.xls" into "Destination.xls".
To achieve this, select the data range in "Source.xls" and then open
"Destination.xls" and select the same data range, and do Edit - paste
special - paste links.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Kanmi" wrote:

I'm working on Excel file called destination.xls then i want to call up
another workbook source.xls to automatic update destination.xls on some rows.
I mean whenever source.xls change then destination.xls should pull automatic
update from it. I taught of using ='C:\My
Documents\excel\[source.xls]Sheet1'!$A$1 OR VLOOKUP FORMULAR .

"NOTE" If i change anything in those rows in source.xls then it should
automatically change the same rows in destination.xls. Please can you help
me and advice on what to do. Thanks alot.