Excel Validation
 

I am tring to make dropdown box "B" only show data that applies to the
selection from box "A". If Amy selected "Perm" from her dropdown dox in "A"
then I only need the (new card
replacement
reactivate card
lost) options to show up. Can you help?


Example:

A: B:
Temp other sites
forgotten
reactivate card


Perm new card
replacement
reactivate card
lost

Contractor new
lost
reactivate


--
Susan Kelly

Excel Validation
 

use data validation to do this..

somewhere on the spreadsheet (in an unused area) put lookup functions
in a cell to pull in the 3 values for each option.

then make the data validation refer to these 3 cells


On Jul 18, 9:10*pm, SKelly wrote:
I am tring to make dropdown box "B" only show data that applies to the
selection from box "A". If Amy selected "Perm" from her dropdown dox in "A"
then I only need the (new card
* * * * * * * *replacement
* * * * * * * *reactivate card
* * * * * * * *lost) options to show up. Can you help?v

Example:

A: * * * * * * * * * * B:
Temp * * * * * *other sites
* * * * * * * * * * forgotten
* * * * * * * * * * reactivate card

Perm * * * * * * new card
* * * * * * * * * * *replacement
* * * * * * * * * * *reactivate card
* * * * * * * * * * *lost

Contractor * * * new
* * * * * * * * * * * lost
* * * * * * * * * * * reactivate

--
Susan Kelly

Excel Validation
 

See Debra Dalgleish's site for dependent dropdowns using Data Validation

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 18:10:00 -0700, SKelly
wrote:

I am tring to make dropdown box "B" only show data that applies to the
selection from box "A". If Amy selected "Perm" from her dropdown dox in "A"
then I only need the (new card
replacement
reactivate card
lost) options to show up. Can you help?


Example:

A: B:
Temp other sites
forgotten
reactivate card


Perm new card
replacement
reactivate card
lost

Contractor new
lost
reactivate

Excel Validation
 

Ok! I understand what you are saying, but now I have another problem I can't
see/ or don't have a tap for validation criteria. Can you help?
--
Susan Kelly


"Gord Dibben" wrote:

See Debra Dalgleish's site for dependent dropdowns using Data Validation

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 18:10:00 -0700, SKelly
wrote:

I am tring to make dropdown box "B" only show data that applies to the
selection from box "A". If Amy selected "Perm" from her dropdown dox in "A"
then I only need the (new card
replacement
reactivate card
lost) options to show up. Can you help?


Example:

A: B:
Temp other sites
forgotten
reactivate card


Perm new card
replacement
reactivate card
lost

Contractor new
lost
reactivate

Excel Validation
 

I'm afraid I don't understand what you are trying to say.

You have another problem you can't see?

I don't know what "don't have a tap for validation criteria" means.


Gord

On Mon, 21 Jul 2008 10:12:07 -0700, SKelly
wrote:

Ok! I understand what you are saying, but now I have another problem I can't
see/ or don't have a tap for validation criteria. Can you help?

Excel Validation
 

I got it. Thank you for your help.
--
Susan Kelly


"Gord Dibben" wrote:

I'm afraid I don't understand what you are trying to say.

You have another problem you can't see?

I don't know what "don't have a tap for validation criteria" means.


Gord

On Mon, 21 Jul 2008 10:12:07 -0700, SKelly
wrote:

Ok! I understand what you are saying, but now I have another problem I can't
see/ or don't have a tap for validation criteria. Can you help?

Excel Validation
 

Now I'll never know what a "tap" is<g


Gord

On Wed, 23 Jul 2008 14:31:00 -0700, SKelly
wrote:

I got it. Thank you for your help.