Help with VB

[Cander]

I have a large Inventory price book that I would like to draw information from. There are 10 columns starting with "code", "quantity", "Piece", "size", "description", "date", "unit","price per brd ft", "brd ft" and "price per lft". On a separate page I would like to have a dropdown list that I can select from the description on the inventory list and bring over the row of the description over to the new sheet. When the row is inserted I would like to fill in the quantity column and then go back to the dropdown list and pick another description item and have it insert the next row below the first one and so on.

Thanks, any help would be greatly appreciated

 

[VoG]

This should be possible using Data Validation and VLOOKUP - see http://www.contextures.com/xlDataVal01.html and http://www.contextures.com/xlFunctions02.html