I have a vacation calendar for work that I'm trying to automate as best as possible.
One of the annoying features is that every year, I have to go in and change all the holidays on the calendar. I'm trying to think of ways to automate the process to an extent.
On the attached sheet, you can see that I have the holidays typed out and on each tab, the dates that show are actually in full date format, so I can test each date against my holidays and determine if that day is a holiday or not. Once I find that it is a holiday, I want to put an 'H' in the column for everyone so that it denotes it is a holiday.
Lets just say for the first tab, January. I want to test all of my dates in B2:AF2 and see if any of those dates match the dates in L23:L32 and if they do match, put an H in the column and if they dont, do nothing.
I could use about a million if statements to say if this day is a holiday, H, if not, blank, however that will bog the sheet down pretty bad.
Can anyone show me a way that I can use one macro to test each date against my holiday range and generate the holiday in the actual calendar?
It will make a bit more sense once you look at the sheet. Please let me know. Thanks!
Bookmarks