Hello - My name is ***** ***** I will be helping you. In order to better assist you I need to know exactly what you are trying to accomplish. Can you give me more details as to what you are trying to do.
Hello Thank you for providing your spreadsheet. I have a better understanding now of what you are trying to accomplish. Just so that I am clear, what you are trying to do is put an x or something for a day that an employee with be out and then when you change the month you are looking for that data to be cleared. Then when you return back to that month you want to see the data that was previously entered.
Although this will able to be accomplished using multiple tabs (one for each month) it is not how the drop down calendar list is used and the functionality that you are requesting is not supported by excel. The reason being is excel does not have data storage in the sense that you can dynamically store or pull data that is not on a given sheet.
You can accomplish what you are asking in excel with some VBA scripting. Here are your options.
Basically - what you are asking for can be accomplished with some VBA scripting but can not be done easily through some excel configuration. I know this is probably not what you wanted to hear. I hope this helps you. If you have any further questions, I will be happy to help.