Prev: Excell mistake in addition
Next: total point
From: rmar on 3 Apr 2010 18:23
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,macro…)))

From: Gord Dibben on 3 Apr 2010 20:09
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 <rmar(a)discussions.microsoft.com>
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,macro�)))

 | 
Pages: 1
Prev: Excell mistake in addition
Next: total point