NataliaMSN
New Member
- Joined
- Mar 16, 2011
- Messages
- 5
I am having trouble creating a macro that looks down a column and looks for duplicate entries and then highlights the entire row,
After it highlights does so I would like it to filter down to only the duplicate in that column so that I can determine what I want to do with those duplicates.
The Column that I am looking for the duplicates in is column G, (because it contains my unique Identifier).
Also is there a way that I can copy all the duplicates to a new worksheet named "Repeaters" in the same workbook ?
Sorry I know I am asking a lot I just am having trouble finding a solution myself and thru google.
Thanks, you guys are awsome!
After it highlights does so I would like it to filter down to only the duplicate in that column so that I can determine what I want to do with those duplicates.
The Column that I am looking for the duplicates in is column G, (because it contains my unique Identifier).
Also is there a way that I can copy all the duplicates to a new worksheet named "Repeaters" in the same workbook ?
Sorry I know I am asking a lot I just am having trouble finding a solution myself and thru google.
Thanks, you guys are awsome!
