Good morning.
I have a list of customer details, including name, address, service pricing, year service performed etc...
I'm looking for a VBA that will find the duplicate addresses (it will need to look at D and E). If they both match then it will merge to the one with the newest year. All data merged will be the newest info and the last column will note the merged years... 2011 and 2012 will turn into 11,12 for example
See attached to make more sense.. The Sample tab is how the list of data will look, the Result tab is how the result of the VBA would look. The actual lists are quite large.
It is also possible that some street names are not written identically. Forth St. and Forth Street for example.. Not sure of the VBA could figure out if this is the same... The duplicates should always be sorted so that they are next to each other, if that helps...
Thanks for your time.
merge_dates_sample.xlsx
Bookmarks