drop down menu

[trey]

i have a drop down menu that when certain items are
chosen within it; result in a value being given to a cell
within my worksheet...im in the mortgags business and im
building a preapproval form...
example....i have a menu: " loan purpose "
the items within it are: refinance, purchase, 2nd
mortgage..etc
when purchase is chose i want another cell within the
worksheet to return a value of .25... please help...

also i have another drop down menu that i want to link to
another sheet within my workbook--basically grab a value
and then return that value to a certain cell within my
sheet...
example: menu of programs- when the program is chosen it
then goes to my rate sheet page - grabs the appropriate
rate from the cell and returns the value to a particular
cell within my sheet...

thanks
trey

 

[biff]

Hi Trey!

If you still want to, you can send me the file:

valko01 who can help is at someplace called comcast period
net.

Biff

 

[Debra Dalgleish]

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)

 

[trey]

i just tried to send it to you and it came back
undeliverable...<[email protected]>..what address do
i need to send it to...
thanks
trey

 

[Biff]

You should be able to decifer this:

valko01 who can help is at someplace called comcast period
net.

Biff

 

[trey]

i went to the site and foudn the file ...that looks like
what i need thanks... question for you though... i go and
create the list on the dummy sheet - do i cut and past
the list to my actual page-- im doing that now and i cant
get the info-- i know im supposed to identify the
destination sheet; but, im having a problem doing that...
plz help
thanks
trey

 

[Debra Dalgleish]

You can leave the list on the other sheet, but you'll have to name the
list. There are instructions here:

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

 

[trey]

im following those instructions; but, the list dsnt
appear on my worksheet...... i named the cell for the
list and then did validation and put under source=
listname...
plz help
trey

 

[trey]

im following the instructions and the info dsnt appear
on my form from the other worksheet... what am i doing
wrong... can you take a look at my form?
trey

 

[Debra Dalgleish]

Create the list
Select all the cells in the list, and name the list

Switch to the sheet where you want the data validation list
Select the cell that will have the list
Choose Data>Validation
Choose to Allow: List
In the Source box, type: =ListName

 

[trey]

thanks i got it to work... now the fun begins...

-----Original Message-----
Create the list
Select all the cells in the list, and name the list

Switch to the sheet where you want the data validation list
Select the cell that will have the list
Choose Data>Validation
Choose to Allow: List
In the Source box, type: =ListName



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know!

thanks i got it to work... now the fun begins...