I have one worksheet with LastName, FirstName, Protocol, IDNumber, etc.column
headings and the "Protocol" Column is redundant. I have approximately 100
different Protocol numbers and would like to separate them into individual
worksheets without having to copy and paste each group of Protocols into a
new worksheet (there are approximately 500+ rows). Is there a way to do this
automatically (function, fomula?)?

Thanks,
Kathy

See Ron de Bruin's site for code. Adjust the column reference to suit or
just move the "protocol" column over to column A

This example copy all rows with the same value in the first column of
the range to a new worksheet. It will do this for every unique value in this
column.
The sheets will be named after the Unique value.

http://www.rondebruin.nl/copy5_4.htm


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 07:01:01 -0700, kjstec
wrote:

I have one worksheet with LastName, FirstName, Protocol, IDNumber, etc.column
headings and the "Protocol" Column is redundant. I have approximately 100
different Protocol numbers and would like to separate them into individual
worksheets without having to copy and paste each group of Protocols into a
new worksheet (there are approximately 500+ rows). Is there a way to do this
automatically (function, fomula?)?

Thanks,
Kathy

Thank you, Gord! It worked perfectly!

"Gord Dibben" wrote:

See Ron de Bruin's site for code. Adjust the column reference to suit or
just move the "protocol" column over to column A

This example copy all rows with the same value in the first column of
the range to a new worksheet. It will do this for every unique value in this
column.
The sheets will be named after the Unique value.

http://www.rondebruin.nl/copy5_4.htm


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 07:01:01 -0700, kjstec
wrote:

I have one worksheet with LastName, FirstName, Protocol, IDNumber, etc.column
headings and the "Protocol" Column is redundant. I have approximately 100
different Protocol numbers and would like to separate them into individual
worksheets without having to copy and paste each group of Protocols into a
new worksheet (there are approximately 500+ rows). Is there a way to do this
automatically (function, fomula?)?

Thanks,
Kathy

Good to hear.

Thanks for the feedback and thanks to Ron(as always)


Gord

On Tue, 14 Apr 2009 10:42:03 -0700, kjstec
wrote:

Thank you, Gord! It worked perfectly!

"Gord Dibben" wrote:

See Ron de Bruin's site for code. Adjust the column reference to suit or
just move the "protocol" column over to column A

This example copy all rows with the same value in the first column of
the range to a new worksheet. It will do this for every unique value in this
column.
The sheets will be named after the Unique value.

http://www.rondebruin.nl/copy5_4.htm


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 07:01:01 -0700, kjstec
wrote:

I have one worksheet with LastName, FirstName, Protocol, IDNumber, etc.column
headings and the "Protocol" Column is redundant. I have approximately 100
different Protocol numbers and would like to separate them into individual
worksheets without having to copy and paste each group of Protocols into a
new worksheet (there are approximately 500+ rows). Is there a way to do this
automatically (function, fomula?)?

Thanks,
Kathy

For Kathy

On the main page (copy5.htm) you can also download a example workbook
with this example and more


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"kjstec" wrote in message ...
Thank you, Gord! It worked perfectly!

"Gord Dibben" wrote:

See Ron de Bruin's site for code. Adjust the column reference to suit or
just move the "protocol" column over to column A

This example copy all rows with the same value in the first column of
the range to a new worksheet. It will do this for every unique value in this
column.
The sheets will be named after the Unique value.

http://www.rondebruin.nl/copy5_4.htm


Gord Dibben MS Excel MVP

On Tue, 14 Apr 2009 07:01:01 -0700, kjstec
wrote:

I have one worksheet with LastName, FirstName, Protocol, IDNumber, etc.column
headings and the "Protocol" Column is redundant. I have approximately 100
different Protocol numbers and would like to separate them into individual
worksheets without having to copy and paste each group of Protocols into a
new worksheet (there are approximately 500+ rows). Is there a way to do this
automatically (function, fomula?)?

Thanks,
Kathy