Creating one scroll-down menu is easy, I just go to tab Data and choose Data validation and can insert a scroll-down menu as a list and just enter the values in this list directly in the Data validation window (no need to reference to any cells containing data).
I would like to do the same thing but now using two dependant scroll-down menues in 2 different cells, this time also by not having to enter data "externally" somewhere on the Excel sheet but handle everything neat and tidy inside this Data validation window. If that is not possible, can I use VBA to achieve this?
An example of the drop-down menues:
Cell A1: Winter;Spring;Summer;Autumn
If "Winter" is selected in A1, then display this scroll-down menu: November;December;January;February;March
If "Spring" is selected in A1, then display this scroll-down menu: April;May
If "Summer" is selected in A1, then display this scroll-down menu: June;July;August
If "Autumn" is selected in A2, then display this scroll-down menu: September;October
Furthermore, I would like to display a hint/info text for each of the alternatives inside the drop-down menu if possible (for example for "December" the hint/info text "Very cold month" should be displayed).