myletterboxnp
New Member
- Joined
- May 20, 2022
- Messages
- 28
- Office Version
- 365
Hi there,
We have a schedule on excel spreadsheet where my team enters their schedule. B4 has name of employee, c4 has either their duty time eg. 9:00 a.m. or "OFF" if they are off. There are like 20/30 employees (B4 down B30) and their schedule (C4 down C20 let's say). Instead of checking individually who is "OFF", I was thinking of, when someone opens the spreadsheet, a popup screen (that can be closed) that shows all the people who are "OFF" on that day, Is that possible?
We have a schedule on excel spreadsheet where my team enters their schedule. B4 has name of employee, c4 has either their duty time eg. 9:00 a.m. or "OFF" if they are off. There are like 20/30 employees (B4 down B30) and their schedule (C4 down C20 let's say). Instead of checking individually who is "OFF", I was thinking of, when someone opens the spreadsheet, a popup screen (that can be closed) that shows all the people who are "OFF" on that day, Is that possible?