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:37 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

Gary''s Student - 29 Oct 2007 10:18 GMT

First reverse the first and second rows. This will put the column headers
directly on top of the data.

Next select a column header and pull-down:

Data > Filter > Autofilter

This will produce pull-downs on all the column headers. Next select from
the header pull-downs a person's first and last name. The filter will now
show only the classes for that person.

The material can now be copied elsewhere.

Signature

Gary''s Student - gsnu200752

> 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

bbarkman - 30 Oct 2007 18:45 GMT

That helps a little if viewing on screen. Now, how would I print this? One
possible format would be like this:

Fred Flintstone
Class 1
Class 2
Class 3

This could possibly be printed on the back of a name tag or on regular paper.

> First reverse the first and second rows. This will put the column headers
> directly on top of the data.
[quoted text clipped - 23 lines]
> >
> > Thanks in advance for ideas.

Reply to this Message

Rate this thread: