thereseexceljakubiak
New Member
Hi my Excel Heroes!!
So, I am in need of your super assistance again!
I update my files, on a daily basis and it would be very helpful to know of the changes that occur on those files. Can someone please help me with a macro to identify these changes?
*The number of columns and column names are always the same.
*The number of rows will always vary
*The type of data with in the cells are always the same (text, date, etc.)
* Some rows get added, deleted, updated
I have researched and found some codes but I need a code to find and match the unique ID# and then copy that row to the "Changes" tab but also to identify, whether its a #1:Change #2:Deletion #3:Addition

I am attaching a sample Book1. Thank you for your help!
https://dl.dropboxusercontent.com/u/35552808/SAMPLE_chandoo_COMPARE.xls
So, I am in need of your super assistance again!
I update my files, on a daily basis and it would be very helpful to know of the changes that occur on those files. Can someone please help me with a macro to identify these changes?
*The number of columns and column names are always the same.
*The number of rows will always vary
*The type of data with in the cells are always the same (text, date, etc.)
* Some rows get added, deleted, updated
I have researched and found some codes but I need a code to find and match the unique ID# and then copy that row to the "Changes" tab but also to identify, whether its a #1:Change #2:Deletion #3:Addition
I am attaching a sample Book1. Thank you for your help!
https://dl.dropboxusercontent.com/u/35552808/SAMPLE_chandoo_COMPARE.xls
Last edited by a moderator: