bobbly_bob
New Member
- Joined
- Mar 26, 2009
- Messages
- 6
We have a sheet used to calculate staff entitlements, unfortunately it now has approximately 30 staff listed and only about one third are current employees.
What I'm planning on doing is using a validated cell with the options of "all", "current", "non-current" which can be selected by the user. Then in row 1 across the page, each staff member will be listed in their column as current or non-current. Depending on which option is selected in the validated cell, I want the appropriate staff members to be hidden / unhidden.
Any help greatly appreciated.
What I'm planning on doing is using a validated cell with the options of "all", "current", "non-current" which can be selected by the user. Then in row 1 across the page, each staff member will be listed in their column as current or non-current. Depending on which option is selected in the validated cell, I want the appropriate staff members to be hidden / unhidden.
Any help greatly appreciated.