Help with the report needed

[ArthurN]

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

 

[cht13er]

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

I set up a userform for this, it felt like the right thing to do, in
order to have an easy way to run stuff.
I would be glad to send the file I have to you .. it has the sheets
you listed, a userform that lets you select the course, class, and
term, and then returns on the sheet a list of all teachers it applies
to.

just send an email to cht13er at gmail do t com and I will send it to
you!

Cheers

chris