Control the information in row of cells by selecting an option from a drop down menu.

Hello All,

I am trying to improve my quote sheet.

I would like to select and option from the drop down menu in column A and have it define what information appears in columns B through to K.

I have attached a copy of the spread sheet with what i would like to fill the cells with.

If someone could provide me with the steps to complete the first column i will do the others by myself. I would really love to know how to do this by myself.

I hope someone out there can help me!

Hi thanks for responding,

I am not sure what a look up is? I only have basic knowledge of excel.

I would like the further drop down menus to change when i select the first columns category.

If you download the sample i have uploaded you can see what i would like to have in the cells for each different categorey in the first drop down menu.

Let me know i