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.
Harry Boughen replied to Jason on 12-Mar-13 11:03 PM
Hello Jason,
In Data Validation select whole number/decimal depending on your requirements.  This gives two windows for minimum - enter 0 and maximum - enter =A1.  Then click OK.
Regards
Harry
Jason replied to Harry Boughen on 12-Mar-13 11:09 PM
Thank you so much! I knew it was something simple, I just couldn't find it.