Drop down menu

[trigger]

Can anybody help me produce a drop down menu on an invoice that allows the user to simply choose from the drop down menu what items are purchsed without having to tyope anything in. I have created an invoice and a stock list within a workbook, i just don't know how to do this.

 

[Audiojoe]

Sure thing:

Write your list in some part of the worksheet, then click on the cell (or cells) you want the list to appear in.

Now click DATA>VALIDATION and you'll see a field with a dropdown called Allow:

Pick LIST from this and then click in the SOURCE field, then click onto your sheet and highlight the list you wrote. Then press Enter and OK.

Now every time you click on the cell you validated, it'll have a drop down list

Audiojoe
My gift is my song and this one's for you
This message was edited by Audiojoe on 2002-04-23 08:42

 

[trigger]

For some reason when i go to highlight the source it will not let me change sheets
:S

 

[Von Pookie]

You can't have a source from a different sheet. I managed to do it by selecting what I needed and naming the range Data.

Then I just put =Data in the source box

 

[lenze]

Data Validation does not allow you to refer to Cell Ranges on another sheet. To refer to a list on another sheet, you must use a named range such as 'mylist' and enter =mylist in the source box

 

[trigger]

Thanks very much for the help!