Excel - vbscript/Macro

[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.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-comparision-vbscript-macros.html#post5253445

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).