In the example below, I would like a macro that creates a new workbook based on the names in column A and copies only data relevant to that name/row. The workbook should also be re-named after the names in Column A.
Name Age Color City
Jack 23 Red SF
Smith 41 Blue NYC
Carrie 33 Green LA
Smith 56 Black LA
That being said, my actual data that corresponds to Column A in the example is located in Column O.
Thanks in advance!
Macro that create a new workbook for each unique value in column