Formula- to create drop down down list based on diff criteria

[Rosana]

Hi,

I needa formula where if i select a certain department all the people
in that department will appear in a drop down list in the template. i
am wondering if we could use IF function to do this....

to give more perspective i am trying to build a travel template which
can be used by all departments in the company to plan their trips but
instead of creating multiple tabs for each department i am wondering
if i could simply create one template and when anyone selects their
department it would automatically put a list of the people (similar to
the way a pivot works but cannot have a pivot as this needs to be a
column in the template.

this would be for the department heads so would make sense if they
could simply chose their department and all the list of their
employees would appear as a drop down.

Any idea?

Thanks!

Rosana

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal02.html

 

[Helmut Meukel]

I think your appoach depends on the way your data ist stored
somewhere. If you can get the names of the employees and the
department they belong to from a database, you could use a
SQL query with the department as parameter to retrieve only
the names belonging to the selected department. Otherwise your
code would have to select the appropriate names. Again the
details how to do this depends on the format of the data and where
you get it from.

Helmut.