Drop down menu

[Stclements1]

I have created a drop down menu consisting of 16 products. In column H of my spreadsheet I list the items that I am trading. For example on H3 I want to have the drop down menu and click on , for example, silver and the text "Silver" is in cell H3 and once a product is selected the drop down list moves to cell H4 where I might select "Copper" and the drop down menu moves down to cell H5 where I may select "Silver" again and the drop down menu moves down to H6 and so on. My question is, is this possible because I have created a drop down but after that I am stuck.

 

[sykes]

Pleasure!