Currently working on a project with 20+ employees with very strict scheduling parameters. We have a time off calendar used to track employee time off - the day they leave and check out of the hotel, the days they're on RR (rest and relaxation), and the days they return to work. But, there are variations of these three items (see document). We want the document to automatically populate the code "RR/E" (rest and relaxation eligible) 28 cells/days after a cell containing "RTW or CI/RTW"
The attachment better explains and shows what I mean.
PLEASE HELP! THANK YOU!
Bookmarks