I am tryin to have 2 in-cell dropdown lists in an excel worksheet.
The list displayed in the 2nd dropdown is dependent on the value selected in the 1st one. Also, there should be the option for user input other than the listed items.
The first dropdown is working fine, and I have clumsily linked the second list to the 1st one by means of a macro triggered by a flag value stored in another cell. But Im sure there is another better way to do this either in Excel or VB
. Can anyone help me? Thanks