Put data into individual worksheets

  • Thread starter Thread starter kjstec
  • Start date Start date
K

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
 
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
 
Thank you, Gord! It worked perfectly!

Gord Dibben said:
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
Click to expand...
 
Back
Top