Thanks Bernie~!
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

"Bernie Deitrick" wrote:

The best approach is to simply don't use your "Updated" workbook: make any changes, additions, or
deletions directly in the "Live" workbook. Having data reside in two places is a recipe for
corruption.

HTH,
Bernie
MS Excel MVP


"x6v87qe" wrote in message
...
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