Morning All,

I have a cell, where depending on the result of another
cell, I would like one of four drop down lists to appear
for the user to make a selection.

Example:

If Cell A1=Monthly then Cell B1 will contain a list of
months to choose from. If Cell A1="Quarterly" then Cell
B1 will contain four quarter months.

Any ideas?