Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula needed to generate report! | Excel Worksheet Functions | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
merge columns into single report - macro needed | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Fill an individual report with values from a team report? | Excel Programming |