Hi,
I've got to get an urgent report ready for my teaching and I'm stuck.
Here's what I have to do:
Report sheet
1. create a combo box displaying subjects listed A1:A150 on the "my data
sheet". This would be the heading of the page. I've done that.
2. below the heading I have additional info: course (1-5), term (1-2)
2. create a code that would search "subjects and teachers sheet" and list
below all the teachers teaching subject (in the combo box) on the, say, 5th
course, in the 2nd term. That's what I can't do.
That's how it sould look:

American Literature
Year 5
Term 2
Teachers: Kevin
               Tom

My "subjects and teachers sheets" looks the following way:
Teacher Subject Course Term
Tom      Am Lit     5         2
Kevin     Am Lit     5         2
Julia      Am Lit     4         2

I would appreciate any help you can give me. Thanks
ArthurN