Updating a master list(Compare and update new data + move new item)

[michellems]

Dear All,

I am updating a master list keep tracking the sales data, which includes old sales record (closed), current record (may have updates) and new records in the "Original" , the current record and new records will be included in the new list.

I would like to see if it is possible to have the data on "New" Sheet being updated with position of the item number not matching the original list.

I read many post about macro doing similar things, and I think the script in this post is pretty good and I like the way it requested user to input which sheet to check?

http://www.mrexcel.com/forum/excel-questions/909209-compare-two-sheets-columns-rows-inserted.html

Old

New

After Merge

After Merge, all new data will be copied to the old file and data will be updated and new items will be generated.
If possible, the changes may be shown in color.

Thank you very much !

 

[michellems]

Sorry. I think I didn't attach the photos successfully.
Please find the snapshoots of my situation in the following links
Old: https://www.dropbox.com/s/tgzavazkdvfabc2/old.JPG?dl=0
New :https://www.dropbox.com/s/c5hmldflhx2fs07/New.JPG?dl=0
After merge: https://www.dropbox.com/s/04dswqp7z0oxezg/merge.JPG?dl=0