auto update function from workbook to another worksheet

[Kanmi]

I'm working on Excel file called Safetylight.xls then i want to call up
another workbook call book1.xls to automatic update safetylight.xls on some
rows. I mean whenever BOOK1.XLS change then safetylight.xls should pull
automatic update from it. I taught of using ='C:\My
Documents\excel\[book1.xls]Sheet1'!$A$1 OR VLOOKUP formula but i'm stuck.
please can you help me and advice on what to do. Please i will appreciate
urgent respond answer. Thanks alot.

 

[James Pranhatkiran]

Check if your vlookup function looks like this, this will serve your purpose.
=VLOOKUP(A2,[Book2.xls]Sheet1!$A:$B,2,0)

here i am writing this function from Book1.xls and referring data from
Book2.xls where the data is in Sheet1

Regards,
James

 

[Kanmi]

Please explain more because it not working yet. Thanks

Check if your vlookup function looks like this, this will serve your purpose.
=VLOOKUP(A2,[Book2.xls]Sheet1!$A:$B,2,0)

here i am writing this function from Book1.xls and referring data from
Book2.xls where the data is in Sheet1

Regards,
James

I'm working on Excel file called Safetylight.xls then i want to call up
another workbook call book1.xls to automatic update safetylight.xls on some
rows. I mean whenever BOOK1.XLS change then safetylight.xls should pull
automatic update from it. I taught of using ='C:\My
Documents\excel\[book1.xls]Sheet1'!$A$1 OR VLOOKUP formula but i'm stuck.
please can you help me and advice on what to do. Please i will appreciate
urgent respond answer. Thanks alot.

 

[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.

Check if your vlookup function looks like this, this will serve your purpose.
=VLOOKUP(A2,[Book2.xls]Sheet1!$A:$B,2,0)

here i am writing this function from Book1.xls and referring data from
Book2.xls where the data is in Sheet1

Regards,
James

I'm working on Excel file called Safetylight.xls then i want to call up
another workbook call book1.xls to automatic update safetylight.xls on some
rows. I mean whenever BOOK1.XLS change then safetylight.xls should pull
automatic update from it. I taught of using ='C:\My
Documents\excel\[book1.xls]Sheet1'!$A$1 OR VLOOKUP formula but i'm stuck.
please can you help me and advice on what to do. Please i will appreciate
urgent respond answer. Thanks alot.