I have a schedule for 50 people with names in a column A and days of the week
in first row: each employee can be assigned to one of four duty stations, be
off, or have vacation (that can be chosen from drop-down list) on a certain
day. That works fine, I get all numbers that I need, but I need separate
sheets for each duty station (4) with 7-10 employees. I tried to use Pivot
Table Report to have employee names show in each duty station sheet, but that
didn't work (if "John" worked at duty station 1 on Monday, but didn't on
Tuesday, his name still showed up on Tuesday's duty station sheet. Is there a
another way to extract names of the employees i.e. assigned to duty station 1
on Monday and so on? I also tried DGET function, but that didn't work either.
Any help would be greatly appreciated.