B
Bill
When you are using Data Validation List, Is there any way
to assign a macro or formula that will choose preselected
entries... for example, I have 10 different cells that
have Validation List assigned to them, I want to be able
to click a button or check box and it automatically
change the value selected in the list with a preselected
list. Click/choose another box
and it will change the value of the list to another
configuration.
to assign a macro or formula that will choose preselected
entries... for example, I have 10 different cells that
have Validation List assigned to them, I want to be able
to click a button or check box and it automatically
change the value selected in the list with a preselected
list. Click/choose another box
and it will change the value of the list to another
configuration.