Hi,
Looking for some help. I would like to create a reducing drop down menu for a range of cells in a column when a value is selected. The example at the link here is essentially what I am looking for: https://www.excelforum.com/excel-ge...-options-reducing-after-every-seclection.html
However I would like to have this over a series on columns. So based on the example that is shown in the link, rather than it applying to column C, I would like this to apply to several columns, but all based on the same range of values in the list.
Looking at the code within the Sheet, it appears that I need to extend the ranges. Rather than applying to column C only, how do I update it to include all columns in my range?
I'm not sure what the protocol is for publishing someone else's script, however happy to update this post if its ok and makes it easier to respond to my query.
Any help would be appreciated.
Thanks,
EMcK
Looking for some help. I would like to create a reducing drop down menu for a range of cells in a column when a value is selected. The example at the link here is essentially what I am looking for: https://www.excelforum.com/excel-ge...-options-reducing-after-every-seclection.html
However I would like to have this over a series on columns. So based on the example that is shown in the link, rather than it applying to column C, I would like this to apply to several columns, but all based on the same range of values in the list.
Looking at the code within the Sheet, it appears that I need to extend the ranges. Rather than applying to column C only, how do I update it to include all columns in my range?
I'm not sure what the protocol is for publishing someone else's script, however happy to update this post if its ok and makes it easier to respond to my query.
Any help would be appreciated.
Thanks,
EMcK