fill drop down list

[Bobnz]

I have a dropdown list in a cell on a spreadsheet where the user selects a name and then all jobs associated with that person are displayed. I want to display only the jobs currently being worked on/ not completed.
Completely new to excel although have done some access programming. I imagine an if statement in dropdown list would solve this problem but where do I find code window? is there a code window?

B

 

[SkipVought]

Bobnz,

alt+F11 toggles between the VB Editor and the active sheet.



Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]

 

[Bobnz]

Thanks skip