Print individual schedule; 1=attend class 0=don't attend

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbarkman - 28 Oct 2007 16:36 GMT

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.

Reply to this Message

JLatham - 28 Oct 2007 23:42 GMT

To prepare for Mail Merge in Word, you need to keep entire records on a
single row. You won't be able to put your 1/0 in the row below a class
location entry.

With multiple classes as you have them, you're probably going to have to
deal with students NOT taking all possible classes in your Word document
setup. Probably want to set up a table in it to contain those entries so it
doesn't look too clumsy by having blank entries in the middle of a paragraph.
Put your 1/0 in a separate column on the same row.

> Worksheet contains headings in first row:
> Last Name, First Name, Class 1, Class 2, Class 3
[quoted text clipped - 10 lines]
>
> Thanks in advance for ideas.

Reply to this Message