I am trying to figure out how to use a drop down list to make a quote sheet.
I have a list of items that have details such as price and size. What i want
to happen is for me to pick the name of the item from a drop down list and
have the other cells with the price and size to fill into their assigned
cell. any suggestions?