Help with the report needed
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 |
Help with the report needed
On Mar 29, 11:08 pm, ArthurN
wrote: 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 |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com