|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.