|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 21st, 2009, 10:03 PM
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
June 22nd, 2009, 11:24 AM
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
June 22nd, 2009, 03:21 PM
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
June 22nd, 2009, 03:53 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
