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 |
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 |
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 |
All times are GMT +1. The time now is 07:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com