Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula- to create drop down down list based on diff criteria
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula- to create drop down down list based on diff criteria
See http://www.contextures.com/xlDataVal02.html
-- HTH Bob "Rosana" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula- to create drop down down list based on diff criteria
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. "Rosana" schrieb im Newsbeitrag ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create list based on criteria | Excel Worksheet Functions | |||
counting dates <= 7 days ago based on criteria in a diff column | Excel Worksheet Functions | |||
multiple ranking (sorting), based on diff. criteria | Excel Worksheet Functions | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Create a list based on single shared criteria | Excel Worksheet Functions |