I apologize in advance that I did not search this forum for my answer. I have been searching google for quite some days now and either they are not explaining it to me in enough laymen or its just not the right situation because of my cell structure. Also im new to this forum so please if my post is in the wrong forum I wont be offended if it is moved.
I am making a schedule calendar template for my work and my main goal right now is I have two lists on a separate worksheet for the month and the year. The dates of the calendar are all on their own rows above the calendar blocks. The top row is the days of the week. I want to know how I can have the month and year selected from the drop down lists and automatically fill in the proper dates with the days of the week.
I have attached the file in question.
Bookmarks