Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto update function from workbook to another worksheet
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto update function from workbook to another worksheet
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" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto update function from workbook to another worksheet
Please explain more because it not working yet. Thanks
"James Pranhatkiran" wrote: 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" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto update function from workbook to another worksheet
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" wrote: 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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update worksheet references as new worksheets are added | Excel Worksheet Functions | |||
Cells w/ user defined function do not auto update | Excel Worksheet Functions | |||
Auto Update Function | Excel Discussion (Misc queries) | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
auto update of copy of workbook | Excel Worksheet Functions |