***UPDATING MORE THAN ONE EXCEL WORKBOOK****

  • Thread starter Thread starter Mpho
  • Start date Start date
M

Mpho

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
 
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.
 
Back
Top