I have a problem that i hope someone can help me with
I need 2 things if possible
I have managed to put together a drop down calendar but i am having problems getting it to work correctly. If you look at my sample sheet you will see if you click any cell in G or H columns the calendar will appear. I would like this changed so that it only appears when i click on cell D1. The date that show only shows the month of January, can we change that to show all months.
Also when i select a date to go in to D1 i would like to add a filter on Colums I, so if i select any date it will filter out any rows from A-Y that are older than that date.
Is this possible?
Bookmarks