Macro need to update the workbook
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
|