View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
lk[_2_] lk[_2_] is offline
external usenet poster
 
Posts: 1
Default ***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

.