Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to lookup information and create report
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create report | Excel Programming | |||
Macro to create report | Excel Programming | |||
Macro to create report | Excel Programming | |||
How to create Macro that can build a Scenario PivotTable Report? | Excel Programming | |||
Using a macro to create a report on another worksheet | Excel Programming |