Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex--don't even know how to word the subject for this
Yes, I was wondering if this could be visualized. The schedules wsheet
has 7 tables on it, visually, stacked on top of one another (there are extra rows between tables for white space). Each table pertains to a school hour, and each column is a different teacher. Under a teacher's name is some other general info, such as the class name (ie. math), grade level, max students allowed, etc. Then, under a teacher's name is a list of the kids. The tables are pre-formatted; there are only 20 rows under a teacher's name--no more than 20 students allowed. The only data that changes are the student names, which are selected from the listboxes. [COLUMN B] Period #1 -------------- TeacherName High School English Max. No. of Students 15 Actual No. of Students 15 -------------- [RANGE1] Student1 -------------- Student2 -------------- Student3 -------------- Studentx -------------- [ROW 40, COLUMN B] Period #2 -------------- TeacherName (same teacher for all of COLUMN B) High School Math Max. No. of Students 15 Actual No. of Students 15 -------------- [RANGE1] Student1 -------------- Student2 -------------- Student3 -------------- Studentx -------------- Hope this helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
how do i move from excell to word for better readable subject | Excel Discussion (Misc queries) | |||
No Subject | Excel Discussion (Misc queries) | |||
No Subject | Excel Discussion (Misc queries) |