Delete a row where a cell in the previous row is a duplicate

B

buscdr

Joined
May 19, 2009
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting and deleting duplicate rows 0
Speeding up a delete rows Macro 6
Deleting Duplicate Rows 12
Deleting duplicate rows 3
Comparing Rows 9
Iteratively delete rows from a spreadsheet 3
Deleting rows 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18

Back
Top