Macro Help

R

redleg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top