I have a unique situation here. I have got a sheet of data and in column F, there are duplicates values containing letter & Numbers like "ORD200002". But these duplicate columns has different set of data in entire row.
I want to run a vba code to search these duplicate data and copy the entire row for all the duplicate values and paste it into another sheet. please help.