how to group conditionally formatted cells in a new location and retain column info

Hello,

I'm a new user, I tried to find a conditional formatting sub forum but didn't see one, hope this Q is ok to post here.

I have successfully highlighted multiple duplicates in a large worksheet with conditional formatting, I now need to group them in a new location , and also retain the info about which column they came from. copy and paste style would be fine. So would a cut and paste action.

There are only 2 columns, but one has 95,000 entries, it's a lot of data. 2013.

Please provide a small sample file with similar data.

Hi,

You'll have to use VBA for automaticly copying the required data into a new location, if you don't want it to do manualy