Build a list of the values you want in each drop down.
Click in the cell you want the Drop Down to appear in, then go to:

From the menu select, Data, Validation, and List.

Refer the list to the cells you've already populated.

--
Dave Eade
EPCS Ltd
www.EPCS.me.uk



"gibbylinks" wrote:

I have inherited a spreadsheet where items are cut and pasted on to the
invoice.

I'd like to improve this by using drop down lists.

Going across i have the following column headings

Quantity - Description - Sales Code - Price - Line Total

What I want is to be able to pick the description and have the sales code
and price (where applicable) filled in automatically.

can anyone give me some pointers as the best way to proceed.

Cheers