I have a long list here and manually doing this will take
couple of hours. Please help with a vba code if you can.

I have a list of customers in about 60 different
territories. this list is in sheet1. I want to run a
code that cuts and pastes all customers in each individual
territory into a newly added sheet.

Column B the list of territories. I have data from column
A to R.

can anyone share with me the full code that I can just
paste in vba window and run?
Thanks so so much.. this will save me bunch of time.

Thrava

Try this code from Ron de Bruin.

http://www.rondebruin.nl/copy5.htm#all


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 09:07:56 -0800, "Thrava"
wrote:

I have a long list here and manually doing this will take
couple of hours. Please help with a vba code if you can.

I have a list of customers in about 60 different
territories. this list is in sheet1. I want to run a
code that cuts and pastes all customers in each individual
territory into a newly added sheet.

Column B the list of territories. I have data from column
A to R.

can anyone share with me the full code that I can just
paste in vba window and run?
Thanks so so much.. this will save me bunch of time.

Thanks I'll try it.
-----Original Message-----
Thrava

Try this code from Ron de Bruin.

http://www.rondebruin.nl/copy5.htm#all


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 09:07:56 -0800, "Thrava"
wrote:

I have a long list here and manually doing this will
take
couple of hours. Please help with a vba code if you can.

I have a list of customers in about 60 different
territories. this list is in sheet1. I want to run a
code that cuts and pastes all customers in each
individual
territory into a newly added sheet.

Column B the list of territories. I have data from
column
A to R.

can anyone share with me the full code that I can just
paste in vba window and run?
Thanks so so much.. this will save me bunch of time.

.