Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update between two workbooks
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. This is working ='C:\MyDocuments\excel\[source.xls]Sheet1'!$A$1 OR VLOOKUP FORMULAR ------------------------------------------------------------------------------ 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" wrote: 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 "Kanmi" wrote in message ... 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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto update between two workbooks
Hi,
Change your formula to .. C:\MyDocuments\excel\[source.xls]Sheet1'!$A1 Hope this helps, Gav "Kanmi" wrote: 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. This is working ='C:\MyDocuments\excel\[source.xls]Sheet1'!$A$1 OR VLOOKUP FORMULAR ------------------------------------------------------------------------------ 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" wrote: 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 "Kanmi" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto update between two workbooks. | Excel Worksheet Functions | |||
Auto update workbooks link | Excel Worksheet Functions | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |