I'm a newbie who has grand ideas which may not be possible.
What I have is a yearly calendar with months across the top and days 1-31 down the left. My colleagues would enter PI for personal illness, or V for vacation and those days are totaled at the bottom of the column for each month. On a separate worksheet I have calculated the stat holidays from current year till forever (I would make a separate calendar worksheet each year).
What I want to do is on the calendar sheet, mark each of the stat holidays with an 'H'. Is this possible?
What I have is a yearly calendar with months across the top and days 1-31 down the left. My colleagues would enter PI for personal illness, or V for vacation and those days are totaled at the bottom of the column for each month. On a separate worksheet I have calculated the stat holidays from current year till forever (I would make a separate calendar worksheet each year).
What I want to do is on the calendar sheet, mark each of the stat holidays with an 'H'. Is this possible?