ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to create report (https://www.excelbanter.com/excel-programming/434945-macro-create-report.html)

redleg

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?


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com