LinkBack URL
About LinkBacks
i want to copy duplicates to a new sheet for instance
Sheet 1
A B C D
A B C D
A B C D
A B! C! D
A B! C! D
A B! C! D
A B! C! D!
New Sheet
A B C D
A B! C! D
A B! C! D!
i want to copy duplicates to a new sheet for instance
Sheet 1
A B C D
A B C D
A B C D
A B! C! D
A B! C! D
A B! C! D
A B! C! D!
New Sheet
A B C D
A B! C! D
A B! C! D!
I found similar ones but I only need to compare A B C D for duplicates and copy A B C D
Hi.
Try..
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi marreco,
The OP wants to compare 4 columns, while you code uses one column only. Beside this, the OP wants to copy the duplicates in to new sheet.
Please Login or Register to view this content.
Yes I am trying to compare columns A, B, C, D with the other columns and then copy only those 4 columns to a new sheet so for my final I would have only one copy of each A, B, C, D on a new sheet. I found code to copy duplicates but it's always the whole row and it compares the whole row.
Please attach a sample with a desired result.
The code AB33 worked nicely! I can add some code to copy it from there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks