Find Duplicates

[HansV]

The code assumes that the data begin in row 2, but they begin in row 6. So you should change the line

col.Add cRow - 2

to

col.Add cRow - 6

[adam]

The Code behind RemoveDuplicates is designed to show only one row of duplicate rows even if three or four rows with same Customer ID exists. The code behind Sub DoFilter() and Sub FilterList() is designed to show all the rows with the same customer ID. How could the code behind be altered so that it shows all the duplicate rows with the same customer ID so that the list box gets filtered with duplicate rows.

[HansV]

You're asking too much again.

[adam]

Never mind. I've solved it for myself & it was easy.