Macro needed to update a spreadsheet

[x6v87qe]

Hi, Group

Basically, I had a query and a worsheet.
The query 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†query 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

 

[KARL DEWEY]

This sounds like an Excel question. I suggest you post your request in a
newsgroup for Excel instead of here, a group for Access a relational database
bt Microsoft.