Thanks Dave~!
Actually, the "updated" file is an export from an access query, which holds
the latest equipments status info. The "Live" file is just another worksheet
in regards those equipments. what I thought is: equipments status
query---"updated" xls---"Live" xls
Maybe I can just use the query to update the equipment info, Can I ?
any better options?

Cheers

"Dave Peterson" wrote:

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, there€„¢s 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 it€„¢s an addition, deletion or just change of value.

Did I make myself clear?

Thanks

--

Dave Peterson