Creating a Progressing Calendar with a Year Look Up

Hello,

This is my first post. I am definitely the most basic of Excel novices, so please excuse any errors or silly questions.

I am in the HR position for a company that uses an excel spreadsheet to track vacation accrual, usage, and holidays. The spreadsheet is complex, so it takes significant time every year to go through and update the calendar portion for the new year.

Going through old items, I found an old calendar someone had been using to track company holidays, and it has a year look-up so all you have to do is change the year and it fills in the correct days. I can't find the data it is drawing from anywhere on the spreadsheet. There is a scrolling bar in the left-hand corner of the spreadsheet that allows you to scroll through the years ranging from 1900-9999, but there is no visible (or hidden) data, just the scroll bar. What am I missing? I would love to figure out how to incorporate this look up into our current HR calendars so I can update all employee calendars with just one click!

Thanks in advance!

~ Crispy

Hi Marvin,

Thanks for the quick reply!

There were hidden sheets, but it was just the two years previous, still no data dump. I'm looking at the VBA properties list for the worksheet, but I can't find anything regarding a code, what am I looking for?

I'm not sure if this is helpful, but this is the formula on each day of the calendar:

=IF(AND(YEAR(FebSun1+1)=TheYear,MONTH(FebSun1+1)=2),FebSun1+1, "")

Thanks!

Here is the example of the calendar that has the formula. You can see the scroll bar in the upper left. I just can't find how it is looking up the correct days by year...

Thank you!