I am creating a spread sheet containing responses from employees from various firms.
Among the criteria which forms part of AutoFilter criteria, there is a value for the employees Year of Experience.
Based on the layout of the responses, I have a macro to take the chosen criteria and applies it to the AutoFilter range.
I have used Data Validation to limit the criteria to only those values present in the response.
In the attached I want the Experience criteria to be a range, but want to limit the list so that the upper value cannot be less than the lower value.
For example, if I choose 7 in cell B1, the list returned in cell D1 only shows "8,9,10".
Does anyone have any idea on how I can achieve this?
Thanks