View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
x6v87qe x6v87qe is offline
external usenet poster
 
Posts: 9
Default 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