Hello,
I work in the IT department at my job and we have these large excel spreadsheets that our are "employee templates." These are to help us know which employees in which departments are to get what applications, access, etc. I am currently working on making these templates more user friendly but I am running into a few snags.
Above is an example of what our templates are like and what I am using to try and figure out what I am trying to accomplish. The templates are organized with a header of the department, and then more headers of the job titles within that department. Then the x's say what applications or access that job title is supposed to get.
My goal is simple: I want sheets in excel holding the data like the image above and then another sheet to filter the data. I want one drop down to list the available departments to pick from and then another dependent drop down that lists only the job titles for the department that was selected in the first drop down. Then, based on the job title selected, it outputs the name in the row of whatever column has a x in it (so if Job2a is selected it lists that Application 2, Application 6, and Application 8 are needed)
I have not messed with filtering the data yet, I've only been trying to get the dependent drop downs to work so far and I'm having trouble. Dependent drop downs are not hard to create, however, I am having a problem with how these templates are set up. I can't seem to get the dependent drop down to recognize the job titles because the data is spread across columns instead of rows
And help on how to accomplish this would be greatly appreciated
I work in the IT department at my job and we have these large excel spreadsheets that our are "employee templates." These are to help us know which employees in which departments are to get what applications, access, etc. I am currently working on making these templates more user friendly but I am running into a few snags.
![ff7p5s.jpg](/board/proxy.php?image=http%3A%2F%2Fi65.tinypic.com%2Fff7p5s.jpg&hash=7d506e8b5a03a97d64befb6db853598c)
Above is an example of what our templates are like and what I am using to try and figure out what I am trying to accomplish. The templates are organized with a header of the department, and then more headers of the job titles within that department. Then the x's say what applications or access that job title is supposed to get.
My goal is simple: I want sheets in excel holding the data like the image above and then another sheet to filter the data. I want one drop down to list the available departments to pick from and then another dependent drop down that lists only the job titles for the department that was selected in the first drop down. Then, based on the job title selected, it outputs the name in the row of whatever column has a x in it (so if Job2a is selected it lists that Application 2, Application 6, and Application 8 are needed)
I have not messed with filtering the data yet, I've only been trying to get the dependent drop downs to work so far and I'm having trouble. Dependent drop downs are not hard to create, however, I am having a problem with how these templates are set up. I can't seem to get the dependent drop down to recognize the job titles because the data is spread across columns instead of rows
And help on how to accomplish this would be greatly appreciated