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

 Blocked Profile -

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 reply

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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!