Identifying duplicate entries in multiple sheets

[bman1132]

Hello all,

I have a workbook I use to track items. Each sheet is a different phase of development. But this sheet is shared between multiple users and often duplicates get left around. I'm looking for a quick way to identify them and alert of their existence (it could be purposeful, so deleting wouldn't be helpful).

There are unique identifiers in columns A and B. So Ideally, excel would check if the values in column A and B for 1 row existed together in another row for column A and B of that sheet or another worksheet. If it found them, it would display a text box indicating the sheet names on which the duplicates were located and their row numbers.

I have some VBA experience but not with anything like this. I've searched the forum but haven't found anything to get me started. Any help would be appreciated.

Thanks

[AndyLitch]

Really need you to upload the file.. otherwise we are shooting in the dark

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick