Macro that create a new workbook for each unique value in column

Anonymous User - May 2, 2016 at 09:59 AM
 Blocked Profile - May 2, 2016 at 06:24 PM

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!

1 response

Blocked Profile
May 2, 2016 at 06:24 PM
Ok, so when is this supposed to happen? Click a button, change a cell?

Post some code and we can help where you are stuck. We cannot design, author, and deploy a turn key solution for you. Post your code, and we can help out!