I have multiple lists setup on one worksheet. I want to return one of those lists depending on what value is entered in another cell.
So if 2 is entered into cell B10 I want a certain drop down list to be shown in cell C10. If 1 is chosen I want a different list shown.
So if 2 is entered into cell B10 I want a certain drop down list to be shown in cell C10. If 1 is chosen I want a different list shown.