Hello Everyone,

I am working on an excel sheet which has data from Col A to Col G.
I first do a conditional formatting for data in Col G to highlight duplicates.

Now I am trying to copy the highlighted (duplicate values) cells in Col G and the entire row to another sheet in the same workbook.
I do this manually of copy > paste each row to the new sheet.

Is this possible to be done by VBA wherein a Macro will copy all highlighted cells in Col G and entire row to another sheet.

PS: I work with data which will have approx 10,000 + rows.. Please can someone assist me with a Macro .. !!

Cheers
Ashyn :-)