michellems
New Member
- Joined
- Apr 19, 2016
- Messages
- 5
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 !
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 !