Checklist in Excel that is dependant on date selected from drop down menu

Hi there,

I have attached a copy of a table which I want to make dynamic (I think this is the right word)

Basically I want a new form (a2:d42) to appear when I choose an option from the drop down list in a1. So instead of having 20 worksheets, one for each checklist, I can use the menu to move between the checklists on the one worksheet.

Any help would be greatly appreciated

Thanks

Good Morning,

Thank you for reading my question,I will try and be more articulate because reading back over my question it was definitely not very descriptive!!! I am also not very good with excel so my lingo is
terrible.

I have attached a copy of a calendar which is similar to what I am looking for.

If you look at the January worksheet - the arrow that moves through the year is similar to what I am looking for, where the the table updates the dates/days relevant to that year. In my case,
I want any data that I record manually in cells B3 to D42 to be dependent on what has been selected from the drop down menu in A1.

In this example, however, when I put the letter d in C7 of this worksheet, it continues to show up even when you change the year. I would like the data in my table to be special to the
option which has been selected from the drop down menu (A1 in my example)

So for the new example I have attached - if it was working the way I need it to, I could put the letter d in C7 in 2016, and it would only appear in C7 if 2016 was selected.

Example:

A1 "02/04/2020 The Other side cafe" is selected from the drop down menu

Data in B3 is text - 16PAX 12pm


BUT

If I change A1 to 03/04/2020 Friendship Friday - I would like the checklist table (A2:D42) to show only data that I enter for that particular date.

So instead of creating a new worksheet for each checklist (i.e one worksheet for 02/04/2020, one for 03/04/2020 etc.) I was hoping that the drop down menu A1 could do the work for me.

Hi there,

I don't think I have explained myself well at all, I am so sorry.

I hope I haven't given you a headache, thank you so much for looking at it for me.

If I get a chance I will research what I am after today and if I find a solution I will post up what it looks like.

Have a great night