Hi,
I have a large spreadsheet that contains customer data. Each customer has a unique customer ID. I would like to loop through the worksheet and delete the second and subsequent rows which relate to the same customer's ID. i.e. I want to delete the old order information and keep the most recent record in the spreadsheet.
Can anyone provide some tips for a macro that would do this?
Regards
Chris
I have a large spreadsheet that contains customer data. Each customer has a unique customer ID. I would like to loop through the worksheet and delete the second and subsequent rows which relate to the same customer's ID. i.e. I want to delete the old order information and keep the most recent record in the spreadsheet.
Can anyone provide some tips for a macro that would do this?
Regards
Chris