Put data into individual worksheets

[kjstec]

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

 

[Gord Dibben]

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

 

[kjstec]

Thank you, Gord! It worked perfectly!

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

 

[Gord Dibben]

Good to hear.

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


Gord

 

[Ron de Bruin]

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