I am trying to create a cell with a drop down menu that contains numbers (i.e. the user chooses from whole numbers between 30 and 50). I would like the numbers contained in the drop down menu to depend on the value in another cell. Specifically, if there is a number in A1 (say, 40) I would like the drop down in A2 to contain all the numbers within +/- 10 of the number in A1 (30 through 50 in this case). I would like it to be dynamic so that if the value in A1 is changed to 50, the drop down in A2 would automatically contain 40 through 60. I have some basic VBA skills if it is easier to go about it that way.
Bookmarks