Auto update between two workbooks.

[Kanmi]

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.

 

[Bernard Liengme]

Have you tired ='C:\My Documents\excel\[source.xls]Sheet1'!$A$1
If both files are open this should work
If 'destination' is closed, it will update next time you open it
Try it and tell us the result
VLOOKUP does not seen appropriate here
best wishes

 

[DILipandey]

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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Kanmi]

Wow! You are Amazing creator. Thanks so much. It working. I apply it to just
one cell and it working but I want apply it to the rows without changing the
rows number manually. Note"When i tried to drag to next cell below it doesn't
change the cell no, it apply the same formula on A2 to A3 then give me the
same result on both cells. If it can change the cell number on the formular
while dragging it down. That will be great.
I'm applying it to cell A2 TO A3000(A2:A3000) stress to start changing
update links and changing cell numbers. please what can i do master? Thanks
so much once again

Have you tired ='C:\My Documents\excel\[source.xls]Sheet1'!$A$1
If both files are open this should work
If 'destination' is closed, it will update next time you open it
Try it and tell us the result
VLOOKUP does not seen appropriate here
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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.

 

[Kanmi]

Wow! You are Amazing creator. Thanks so much. It working. I apply it to just
one cell and it working but I want apply it to the rows without changing the
rows number manually. Note"When i tried to drag to next cell below it doesn't
change the cell no, it apply the same formula on A2 to A3 then give me the
same result on both cells. If it can change the cell number on the formular
while dragging it down. That will be great.
I'm applying it to cell A2 TO A3000(A2:A3000) stress to start changing
update links and changing cell numbers. please what can i do master? Thanks
so much once again

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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

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.