Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Print individual schedule; 1=attend class 0=don't attend
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. "bbarkman" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print individual schedule; 1=attend class 0=don't attend | Setting up and Configuration of Excel | |||
Print individual schedule; 1=attend class 0=don't attend | Excel Discussion (Misc queries) | |||
Print individual schedule; 1=attend class 0=don't attend | Excel Discussion (Misc queries) | |||
assign commission schedule to an individual | Excel Discussion (Misc queries) | |||
How do I create a search engine for a class schedule in Excel? | Excel Worksheet Functions |