TAPS_MikeDion
Well-known Member
- Joined
- Aug 14, 2009
- Messages
- 622
- Office Version
- 2011
- Platform
- MacOS
Hi everyone,
I've done some searching, but couldn't find this exact scenario.
I have rows of employee names on one sheet with Checkboxes across several columns (we'll call it EmpSheet.) If an employee works at a location listed in one of the columns, then that Checkbox is checked. One employee can be working at several locations.
There are as many sheets as there are columns on the employee names/work locations sheet (EmpSheet.)
For example:
Tom only works at Location A
Jane only works at Location B, and
Mark works at Locations A & C
In addition to EmpSheet, there would be 3 additional sheets (Location A, B and C).
All employee names are on every location sheet (links form EmpSheet), but I would like to have ONLY the employee(s) working at any given location to show on the Location sheet(s). All remaining employee names would be hidden on any given Location sheet if that employee does not have the box checked for that Location on EmpSheet.
Thanks to anyone offering help!
I've done some searching, but couldn't find this exact scenario.
I have rows of employee names on one sheet with Checkboxes across several columns (we'll call it EmpSheet.) If an employee works at a location listed in one of the columns, then that Checkbox is checked. One employee can be working at several locations.
There are as many sheets as there are columns on the employee names/work locations sheet (EmpSheet.)
For example:
LAST | FIRST | LOCATION A | LOCATION B | LOCATION C |
---|---|---|---|---|
Brown | Tom | [ X ] | [ ] | [ ] |
Doe | Jane | [ ] | [ X ] | [ ] |
Smith | Mark | [ X ] | [ ] | [ X ] |
Tom only works at Location A
Jane only works at Location B, and
Mark works at Locations A & C
In addition to EmpSheet, there would be 3 additional sheets (Location A, B and C).
All employee names are on every location sheet (links form EmpSheet), but I would like to have ONLY the employee(s) working at any given location to show on the Location sheet(s). All remaining employee names would be hidden on any given Location sheet if that employee does not have the box checked for that Location on EmpSheet.
Thanks to anyone offering help!