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