***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

***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

.

***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