Excel - updating records by comparision - VBScript/Macros

[sowmyareddy]

• Hi,
  
  Can someone please provide me a VBScript code for my below requirement.
  
  I have a master tracking document that I use to record project information. My client sends me an updated schedule each week which may (or may not) have additional stores on it and some of the details of the stores may have changed. I need a macro to capture these changes from the source spreadsheet (the one the client sends) and update the master tracker. The master tracker has a lot of additional columns of data that I add in myself about each project so I don't want to lose this information. The macro needs to see if the store on the source sheet is already on the master tracker and if it is then it needs to check to see. If the store isn't on the master tracker then it needs to be added. Also, delete any rows from the master tracker if they have now been removed from the source workbook.
  
  Master Spreadsheet
  
  Column A - Member
  Column B - Description
  Column C - Structure-1
  Column D - Structure-2
  Column E - Structure-3
  Column F - Currency
  Column G - Geography
  Column H - Business
  
  
  Source Spreadsheet
  
  Column K - Member
  Column L - Description
  Column M - Structure-1
  Column N - Structure-2
  Column O - Structure-3
  Column P - Currency
  Column Q - Geography
  Column R - Business
  
  
  Quick response would be appreciated!
  
  Thanks in Advance.
  
  Regards,
  Sowmya​

 

[oldbrewer]

I cannot help further - bump the thread and maybe PM Fluff - he is a macro expert.

 

[sowmyareddy]

Could someone please help me in this. Would be very thankful.