Microsoft Excel - How to limit the range of a validation list based on the contents of another cell
Asked By Jason on 09-Mar-13 06:42 PM
I feel like this should be fairly simple, but I can't find any help in the matter.
Basically, I want to limit the numerical range of a validation list, based on the number within another cell.
Let's say A1 is 10, I want my validation list in B2 to range from 0 to the value of A1, which in this case would be 10.
Thank you in advanced.