Copy data from column into new sheet

[navyret2009]

I have an excel workbook that has duplicate values in column A, and distinct values in column B. What I would like to do is find all the duplicate values in column A, copy data from A and B into new sheet named after duplicate value.

 

[Joe4]

Welcome to the Board!

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

When you find a duplicate, it is not quite clear if you want to keep one record on the original sheet, or move everything to the other sheet.
Can you also show us a quick sample of your data and expected output?
I think that will help clarify exactly what you are looking for.