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