I hope someone can possibly help...
I have a cell with a drop down (AE9) that generates limits in cells Y17-AS17. The user inputs their information in row Y24-AS24 that has data validation based on the cells above.
If the user were to change the dropdown value in AE9, the limits change but the validation doesn't take place again.
Can the user input cells of Y24-AS24 zero out whenever the user changes the dropdown choice?
I hope I have articulated the problem well enough and thank you all in advance for the help.
I have a cell with a drop down (AE9) that generates limits in cells Y17-AS17. The user inputs their information in row Y24-AS24 that has data validation based on the cells above.
If the user were to change the dropdown value in AE9, the limits change but the validation doesn't take place again.
Can the user input cells of Y24-AS24 zero out whenever the user changes the dropdown choice?
I hope I have articulated the problem well enough and thank you all in advance for the help.