Macro needed to update a spreadsheet

[Guest]

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

 

[Roger Carlson]

Not entirely clear, but on my website (www.rogersaccesslibrary.com), is a
small Access database sample called "ExportToExcel.mdb" which might give you
some ideas.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L