Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS excell 2007 Data verification list
I am attempting to use the list function within data verification for drop
down menus. I need a list that is conditional upon the information in another cell. Example: The first cell offers a drop down menu with specific Make of equipment. From what appears in that cell I seek to offer only the Models for that Make of equipment on a list in another cell. I considered using a series of IF statements to run macros however I dont know how to invoke a macro from within a formula. Any suggestions? Thank You =if(€śTrane€ť,macro,=If(Crrier,macro,=If(Bitzer, macro€¦))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS excell 2007 Data verification list
See Debra Dalgleish's site for help on creating dependent lists.
http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Sat, 3 Apr 2010 15:23:02 -0700, rmar wrote: I am attempting to use the list function within data verification for drop down menus. I need a list that is conditional upon the information in another cell. Example: The first cell offers a drop down menu with specific Make of equipment. From what appears in that cell I seek to offer only the Models for that Make of equipment on a list in another cell. I considered using a series of IF statements to run macros however I don’t know how to invoke a macro from within a formula. Any suggestions? Thank You =if(“Trane”,macro,=If(Crrier,macro,=If(Bitzer,mac ro…))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative percentage in data verification dropdown list? | Excel Discussion (Misc queries) | |||
How to delete unpinned worksheets from list in Excell 2007 | Excel Discussion (Misc queries) | |||
Data Verification between worksheets | Excel Worksheet Functions | |||
data verification question | Excel Worksheet Functions | |||
data verification | Excel Discussion (Misc queries) |