Show/Hide rows in another sheet based on Checkbox

[TAPS_MikeDion]

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:

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!

 

[TAPS_MikeDion]

Bump.