Moving duplicates in column A to new excel file

June 12, 2012 at 08:50:21
Specs: Windows XP
I have Windows XP, Excel 2007. Is there a way to use a function or command to consolidate and move duplicate values in column A and the data in the corresponding row to a new excel file, entitling the tab of that value in column A?

For example: I have a worksheet with 20,000 rows. In column A are approximately 60 different names. Columns B – H reflect data related to the name in column A. I want to use a command or something like that to move all of “John Smith’s” data to a new excel file entitled the tab in the workbook “John Smith”, and then doing the same with the next name, and so forth. Moving the data is more important to me than getting the tab to have the name of the person on it...

Edit: If not able to move to a new workbook, moving to a new worksheet would work as well.

Although I have a good working knowledge of Excel, I do not have experience with writing formulas or macros. Assistance would be greatly appreciated. Thank you.


See More: Moving duplicates in column A to new excel file

Report •

June 13, 2012 at 05:50:44
Anyone? Or is this not possible? This is a monthly report I run so It will help me in the future as well. Thanks

Report •
Related Solutions

Ask Question