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