So, I'm using Excel 2007, and I have made a drop down menu with certain items
in it. I want to make it so that when I select an item from the drop down
menu, a number appears in a seperate column depending on which item I chose
in the drop down menu. Hope that made sense, thanks for reading.