If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filtering simply
I have a sheet which looks like this (in reality there are 84 names by
around 30 skills): person skill 1 skill 2 skill 3 tom yes barbara yes gerry yes margo yes yes yes view staff with which skill?.......... I want to offer a box to allow the user to choose a skill and be given a list of the staff that have that skill. In the example, 'skill 1' should return: tom margo and 'skill 2' should return: barbara margo etc Even better would be to allow combinations of skills, such as skill 1 and skill 2 which should return just 'margo' the sheet is for use by very basic users and I can't expect them to apply a filter - ideally I'd just like them to be able to click on a box or choose a skill or skills from a pull down box. I can't use VBA either so I need a normal non-VBA solution. Any thoughts? |
#3
|
|||
|
|||
filtering simply
I would have to do it for every request, 24hrs a day 7 days a week. Or, to
do it in advance means doing every combination of skills that might be required and repeating the exercise everytime someone joins or leaves or adds a skill to their repertoire (there are 84 people involved). The only sensible way I can think of is for it to be interactive. I considered colouring every name white, if it didn't have the requested skills associated with it but I'm afraid this is beyond me too. "merlin" wrote in message ... I have a sheet which looks like this (in reality there are 84 names by around 30 skills): person skill 1 skill 2 skill 3 tom yes barbara yes gerry yes margo yes yes yes view staff with which skill?.......... I want to offer a box to allow the user to choose a skill and be given a list of the staff that have that skill. In the example, 'skill 1' should return: tom margo and 'skill 2' should return: barbara margo etc Even better would be to allow combinations of skills, such as skill 1 and skill 2 which should return just 'margo' the sheet is for use by very basic users and I can't expect them to apply a filter - ideally I'd just like them to be able to click on a box or choose a skill or skills from a pull down box. I can't use VBA either so I need a normal non-VBA solution. Any thoughts? |
Thread Tools | |
Display Modes | |
|
|