Help in creating a list with a drop down menu

[Wolves67]

I would like to create a worksheet that allows me to have a drop dow
list that will pick products and services.

What I'd like to know is.

1. How do I create the drop down list? (I have no VB skills)

2. How do I create a formula for each of the options on the menu?

Any help you guys can offer will be very much appreciated.

Thanks
Dav

 

[Debra Dalgleish]

You can create dropdown lists with Data>Validation. There are
instructions in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html

There's a sample file on my web site that uses Data Validation and
VLookup to complete an order form. You could use the same technique for
your worksheet:

http://www.contextures.com/excelfiles.html

Look for the heading: Order Form (DataValOrder.xls)

 

[Wolves67]

Thanks