Macro for creating new workbooks based on unique cell value

[MCHR]

Dear all,

I am curious if there is a macro that would do the following :

Locate matching cell data within a colomn (A), copy all rows that have a match with that cell and create a new workbook for those specific rows, concerning coloms A to H.
If possible i would also like to set the name for the new workbook to be based on cell from colomn B, and if possible specify the folder where they need to be created.

Imagine you have a mass extraction of balance sheets from your customer database containing 80 clients, each with their own specific details.
Colomn A to H, where A would be the criteria to copy to a new workbook (customer number) and B would be the name of that new workbook (customer name), colomns C to H contain unique data.

Location could be Desktop/MassExctraction

The macro would create 80 workbooks within the folder, name of the workbook would be matching with the customer name and the workbook would only contain customer specific data.

Looking forward to hear from you !

KR

Marcel

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.




To add a file to a post

[MCHR]

Hi Dave,

Thanks for the reply, i cant really attach anything because of private info. My description is pretty clear though?

If something is not clear please let me know

[davesexcel]

It's called a sample workbook for a reason.

Your description may be clear, but are you expecting somebody to recreate the workbook when you have it made already?

[MCHR]

No i would just need the macro
But np ill try to provide a sample

[MCHR]

i have made a sample but unable to attach (icon won't work)

So basically i will describe it in the most simple way :

I want the macro to create new workbooks for each unique value within colom A.
Colom A would be the customer name, so if customer names are Customer 1, 2 etc. to 5, the macro should create 5 workbooks.

Each workbook would be named in accordance to value of Colom A, so customer 1, customer 2, customer 3, customer 4, customer 5.

In the new workbooks, all data should be placed of any other colomns that contain data in the original file in which the macro was run, based on colom A.
So if in the mail file customer 3 appears 10 times in colom A, with values in the other colomns, than new workbook for customer 3 would contain 10 lines resembling the data as mentioned in the original file.

As i would like to apply this macro to all kinds of data and also future data, i prefer that it is created for all coloms and rows, to avoid some not being copied based on set restrictions.

Basically the thought behind is that if you have a massive customer database, the macro would create a workbook for each customer containing the data from the orginal file for only that customer.

Hope this is a bit clear now.