DROP DOWN QUESTION.xlsx If you take a look at the attached file, is there a way I can get A1 to be a drop down menu that holds 1, 2, 3, 4 in it? When 1 is picked cells (A2:A4) show the values of the 3 cells directly under the 1 column (i.e. .3, .2, .8 in cells A2, A3 and A4 respectively). The same goes for when 2, 3 or 4 or picked from the drop down.
Bookmarks