KristinaElise
New Member
- Joined
- May 31, 2012
- Messages
- 12
Hello,
I am in need of some help! I've got about 7 sheets with data (however it may go up to 30 sheets). I need to find a way to compare all sheets for duplicate records. If there is a duplicate record, I then need each version of that record to be pasted to a new sheet.
I would be basing the term "duplicate" on any data that has the same information in one column (though each record has multiple colums). So for example, in the following, B is my column of interest:
A B C
1 apple eat happy
2 orage eat sad
3 pear not eat glad
4 banana not enjoy both
I would therefore consider rows 1 and 2 to be duplicates and would need these rows copied to a new sheet.
Is there a way to do this? Any help would be much appreciated!!
I am in need of some help! I've got about 7 sheets with data (however it may go up to 30 sheets). I need to find a way to compare all sheets for duplicate records. If there is a duplicate record, I then need each version of that record to be pasted to a new sheet.
I would be basing the term "duplicate" on any data that has the same information in one column (though each record has multiple colums). So for example, in the following, B is my column of interest:
A B C
1 apple eat happy
2 orage eat sad
3 pear not eat glad
4 banana not enjoy both
I would therefore consider rows 1 and 2 to be duplicates and would need these rows copied to a new sheet.
Is there a way to do this? Any help would be much appreciated!!
Last edited:
