Adding values to drop down lists that are selected by users

Hello,

I'm looking to add values to drop down lists. I want to be able to select a product from a drop down list and then it will update rows with values such as: unit price, unit buy price, unit sell price etc

i will attach a spreadsheet so you can see what i mean. the drop down lists are on the left.

Any help very much appreciated

Originally Posted by blastranger

maybe you need price per product table before you can get any automated price

Think i got sorted. Came across this it tells me how to do everything i want

http://www.contextures.com/xlOrderForm01.html