I'm working on 2 employee schedules, I'm trying to get cells in one schedule
to reference another (person works at both facilities). the problem I'm
having is, I want the cells at the second facility to reference the first and
differentiate between days on, off and at the other facility. making it so I
only have to enter this info once thus eliminating discrepences. I have both
on one sheet. any help would be great.