Excel sort for duplicate records
Posted on 2016-08-27
I have a big Excel worksheet with Name & Contact information entered. It probably has close to 2,500 records.
I want to transfer all the sheet tabs into a new worksheet without certain columns and without their column row headings.
After I do all that I am going to sort for duplicate records.
I know in all this there are Company Names listed more than once in more than 1 category.
I want to create inquiry cards to send to these companies.
So far, I have transfered the tab information into a whole new workbook of its own.
I would like someone to tell me how they would have transferred these tabs to a new sheet (because it seems I probably did it the long, hard way because I had some issues I had to fix)
and I really want someone to walk me through setting up the sort process to get to the duplicate records.