I manage a class where I create a daily report of students out of class from
a roster of all students and current status. I need to create a macro that
will look at the HOLD CATEGORY column and if it matches RECYCLE the macro
will enter the Student's NAME and STATUS into a specfic section of another
worksheet I use as a daily report.

I.E. on the roster has
NAME HOLDCAT STATUS
Jon Doe Recycle D Co

and the report on a seperate worksheet has
NAME STATUS
Jon Doe D CO

I need the macro to scrub the entire HOLD CAT column of the roster and be
able to put the name and status in different sections of the report worksheet
based on the different HOLD CAT categories.