Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
***UPDATING MORE THAN ONE EXCEL WORKBOOK****
Hi! excell programmers,
I need ur help very urgent. Problem: I have three different excel documents[in different locations] and both contain a portion of the same data. If i make changes to workbook1, the changes must appear to workbook 2&3. Lets say cell rage a20:k20 is the same for both workbooks, If i make changes to workbook1 for range a20:k20 then the changes must also appear in workbook 2&3 in range a20:k20. I hope i made myself clear. Your help it is very appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
***UPDATING MORE THAN ONE EXCEL WORKBOOK****
Don't shout!!
-----Original Message----- Hi! excell programmers, I need ur help very urgent. Problem: I have three different excel documents[in different locations] and both contain a portion of the same data. If i make changes to workbook1, the changes must appear to workbook 2&3. Lets say cell rage a20:k20 is the same for both workbooks, If i make changes to workbook1 for range a20:k20 then the changes must also appear in workbook 2&3 in range a20:k20. I hope i made myself clear. Your help it is very appreciated. Thanks . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
***UPDATING MORE THAN ONE EXCEL WORKBOOK****
Right click on the worksheet tab in Workbook1 and select view code.
At the top of the resulting module, select worksheet in the left dropdown and Change in the right dropdown. the argument to the Worksheet_Change Event, Target, will contain a reference to the cell(s) that was/were changed. You can use this information to then update the two other workbooks. -- Regards, Tom Ogilvy "Mpho" wrote in message ... Hi! excell programmers, I need ur help very urgent. Problem: I have three different excel documents[in different locations] and both contain a portion of the same data. If i make changes to workbook1, the changes must appear to workbook 2&3. Lets say cell rage a20:k20 is the same for both workbooks, If i make changes to workbook1 for range a20:k20 then the changes must also appear in workbook 2&3 in range a20:k20. I hope i made myself clear. Your help it is very appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating Excel workbook | Excel Worksheet Functions | |||
Excel 2003 workbook not updating values | Excel Worksheet Functions | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
updating excel worksheets to another workbook | Excel Worksheet Functions | |||
Transparently updating another workbook from the current workbook | Excel Programming |