You've made yourself clear, but excel isn't really good at doing this kind of
thing.

You may want to consider putting the data in one worksheet, add a indicator
column (Live or not-Live), then use data|filter|autofilter to show the data you
want.



x6v87qe wrote:

Hi, All

Basically, I have two workbooks and each of them contains a single worksheet.
The first worksheet namely €œUpdated€� has 8 columns, while the other
worksheet €œLive€� has 16 columns (8 of them are same with €œUpdate€�, rest are
different).
However, both of them have a same indicate column €œEquipment ID€�.

What I need is to use the €œUpdated€� sheet to update the €œLive€� one. That is
whenever, theres a change in the €œEquipment ID€� of €œUpdate€� I need the
changes .including all other 8 columns, to be reflected on the €œLive€� sheet,
no matter its an addition, deletion or just change of value.

Did I make myself clear?

Thanks

--

Dave Peterson