Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to create report
I manage a training company and must track students on an excel roster. I
print off a daily report of class statistics and detailed information on the students no longer in class. I am trying to develop a macro that creates a report from my main roster. I.E. if a student is pending recycle then they have RECYCLE in the holdover column - the macro inserts their name and paperwork status in the appropriate column and rows in the report worksheet because of the holdover column text. Along the lines of IF M2 = "RECYCLE" insert C2(Last Name) into the report worksheet C26(Recycle category name column) and insert O2(Paperwork Status) into C27(Recycle category status column). The macro will have to recognize different holdover categories and then put the pertinent information into the different report sections on a seperate excel worksheet. Can anyone point me in the right direction or to previous posts that outline a similar macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create report | Excel Programming | |||
Macro to create report | Excel Programming | |||
How to create a macro to generate report using advanced filter | 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 |