VB Macro to review and remove/delete duplicates within same column
Posted on 2013-01-31
I'm looking for a VBA Macro that can go into one column, (Column E for example). The column will hold a 14 digit client record, when there is any change to a client record the 14th digit is changed (example 13013178910100 will become 13013178910102, and if altered again will become 13013178910104). Is there a way to code the Macro so that it would keep the client record with the highest 14th digit and recognize the rest as duplicates and delete that row?