ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print individual schedule; 1=attend class 0=don't attend (https://www.excelbanter.com/excel-programming/400153-print-individual-schedule%3B-1%3Dattend-class-0%3Ddont-attend.html)

bbarkman

Print individual schedule; 1=attend class 0=don't attend
 
Worksheet contains headings in first row:
Last Name, First Name, Class 1, Class 2, Class 3

Second row contains class locations underneath the class names (for
reference).

I enter a 1 or 0 in the cells for each attendee; 1 if attending class, 0 (or
blank) if not attending.

Next, I would like to build an individual schedule with the class names for
each attendee based on the 1's entered. Hopefully, this can be printed later
via mail-merge with Word.

Thanks in advance for ideas.


All times are GMT +1. The time now is 01:13 AM.

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