Copy and paste all data into multiple new workbooks based on cell data

[mytsurfer]

Need help. Wanting to take customers in Column B and create new workbooks for each customer and copy and paste that data into the new workbook for just that customer. The workbook would need to be titled the name of the customer as well. Columns go to BL so all data to be copied over. Sample data attached.

Thanks in advance.

[vba_php]

hmmmmmm. well......maybe this?

Please Login or Register  to view this content.

[mytsurfer]

Thanks Adam.
Close. It created a new workbook for each row and I am sorry if I wasn't direct - but it should filter out per customer and save that data together. For example Company 4 had 4 rows of information. Instead of creating each row seperately I would like those all in one file under - "Company 4".
Chris.

[vba_php]

that is very easy to do, Chris. do you have any experience with VBA? with little research, you could do it. want to give it a try? that's about 5 - 10 lines more lines of code, if that.

[mytsurfer]

for sure. I will give it a try tonight and post code if I can't figure it out. Thanks.

[vba_php]

good! nice initiative. glad to hear. there are a million people here who can assist, if necessary.

[mytsurfer]

Hi Adam,
Searched and played with it and found that this works best for what I am looking for. I know it doesn't follow your example, but really appreciate the help and wanted to post this incase anyone else was looking to do something similar. I created a send worksheet to where I would have the path (Cell E2) and paste the contact names and remove duplicates to create a unique value of contacts.

Please Login or Register  to view this content.

Thanks Chris