In response to an earlier request, I was able to create a pull down list in a column. Now I need to create a second pull down list with the values depending on the selection of the first pull down list.
If value "A" is selected in the first list, the second list is to show the values in range B1:B100. If "B" is selected, the values in the second list is to show the values in range C1:C100. If "C" selected, the range should be D1:D100 and so on. How do I set this in the second pull down list?
If value "A" is selected in the first list, the second list is to show the values in range B1:B100. If "B" is selected, the values in the second list is to show the values in range C1:C100. If "C" selected, the range should be D1:D100 and so on. How do I set this in the second pull down list?