Hello all,
I have a long list of data with one column being a customer
I would like to divide into separate workbooks each customer's data
I have a separate worksheet within the same workbook that has a list of the customers themselves there are two types of customers which i have made easier to identify by placing a 1 or a 2 in an adjacent column to the customer name
What i would like to do is to first delete all the data that contains a number 2
then i am sorting the data by customer (done already)
then i need to read through each customer and copy paste their data onto a new workbook by itself
So for example if i have 4 customer's data in my initial sheet i need to end up with 4 additional workbooks each containing its individual data.
I hope i explained my self..... let me know if you need any further information.
I have a long list of data with one column being a customer
I would like to divide into separate workbooks each customer's data
I have a separate worksheet within the same workbook that has a list of the customers themselves there are two types of customers which i have made easier to identify by placing a 1 or a 2 in an adjacent column to the customer name
What i would like to do is to first delete all the data that contains a number 2
then i am sorting the data by customer (done already)
then i need to read through each customer and copy paste their data onto a new workbook by itself
So for example if i have 4 customer's data in my initial sheet i need to end up with 4 additional workbooks each containing its individual data.
I hope i explained my self..... let me know if you need any further information.
