New Tab with Customer Name and data

[Cpreston]

Hi

I have a list of customers in a data sheet with 5 other columns of data relating to the customer.

I want to do the following from the data sheet.

In the same workbook create a new tab from the customer name and also copy in all the other column information relating to that customer.

So if I have 5 different customer names in the main data sheet, I will have 5 new tabs with their names on the tabs and also the information relating to that customer in the named sheet.

I have found a lot of code where I can name the tabs, some work ok, but none where it takes the related columns and rows also.

Any help please. Thanks in advance

 

[SkipVought]

Hi,

Please post in forum707, which is dedicated to VBA solutions for Office Applications.

BTW, its not really a sound approch to chop your data up into sheets. You have filters that can do that all on one sheet.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Cpreston]

Thanks have posted it on there. I appreciate I could use the filter, but I need to separate the customer information to make it easier for another rperson to use the information.


Thanks

 

[SkipVought]

Your users cannot use AutoFilters?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}