I need assistance in writing vba to remove duplicate rows based on oldest date. I have a worksheet that is an update sheet. This sheet finds the current record with a number of columns that feed a form. The user will make necessary changes to the record and hit a command button which updates the record by finding the next empty column. I need the updated record to find the oldest record (which should only be one record) and delete it and keep the most current record.
The two columns that it needs to compare is "A" (a ZIP Code column) and "B" (the date column).
Your assistance is appreciated