auto update function from workbook to another worksheet

  • Thread starter Thread starter Kanmi
  • Start date Start date
K

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.
 
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
 
Please explain more because it not working yet. Thanks

James Pranhatkiran said:
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 said:
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.
Click to expand...
Click to expand...
 
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.

James Pranhatkiran said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top