Data in Columns doesnt change when the year and month do

Hello,

I have been trying to make an attendance record for my work but I am having some trouble making the spreadsheet save data within the columns as a new month appears. I have it generated so the date changes with the month and year when they change but I am unable to make any data stick as the months change. I've tried to look it up online and cant seem to find anything.

I think the response in your other thread will also answer this question, although the other thread is more concerned with avoiding weekends.

In both threads it would help if you attached a sample Excel workbook by following the guidelines in the yellow banner at the top of the screen.

Hope this helps.

Pete

I have attached a sample book

I changed your month drop down control, may be you like it more this new way.