drop down menu

  • Thread starter Thread starter trey
  • Start date Start date
T

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
 
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
 
You should be able to decifer this:

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

Biff
 
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
 
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
 
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
 
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
 
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

.
Click to expand...
 
Back
Top