View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bbarkman bbarkman is offline
external usenet poster
 
Posts: 10
Default 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.