Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve R
 
Posts: n/a
Default Data Validation - Drop down lists - if then?

I have a spreadsheet with two tabs. The first is the working tab, the second
is for lists.

On the first page I have a drop down list. Is there a way to have a second
drop down list that allows the list selection to change based on the choice
made on the first list?

I other words: If list A has a choice of Coke, Pepsi, or Dr.Pepper... is
there a way to make the second drop down list change (between three
corresponding lists) dependent on what soft drink the user chooses???

And if so, how do I do it? In lamens terms please, I am an intermidiate user.

Thanks,
Steve
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

There are instructions here for dependent data validation lists:

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


Steve R wrote:
I have a spreadsheet with two tabs. The first is the working tab, the second
is for lists.

On the first page I have a drop down list. Is there a way to have a second
drop down list that allows the list selection to change based on the choice
made on the first list?

I other words: If list A has a choice of Coke, Pepsi, or Dr.Pepper... is
there a way to make the second drop down list change (between three
corresponding lists) dependent on what soft drink the user chooses???

And if so, how do I do it? In lamens terms please, I am an intermidiate user.

Thanks,
Steve



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

  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Yes, see:


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


Regards,

Peo Sjoblom

"Steve R" wrote:

I have a spreadsheet with two tabs. The first is the working tab, the second
is for lists.

On the first page I have a drop down list. Is there a way to have a second
drop down list that allows the list selection to change based on the choice
made on the first list?

I other words: If list A has a choice of Coke, Pepsi, or Dr.Pepper... is
there a way to make the second drop down list change (between three
corresponding lists) dependent on what soft drink the user chooses???

And if so, how do I do it? In lamens terms please, I am an intermidiate user.

Thanks,
Steve

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation not showing drop down Lily Excel Worksheet Functions 1 April 1st 05 07:13 PM
Change font size in drop down validation lists Big Daddy Excel Discussion (Misc queries) 2 February 3rd 05 06:22 PM
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow Scott Excel Discussion (Misc queries) 1 February 1st 05 02:51 PM
how do I add data validation dropdown lists to a Form SteveD.IFlora Excel Worksheet Functions 3 January 21st 05 05:48 PM
Data Validation Lists Kathy - Lovullo Links and Linking in Excel 1 December 14th 04 03:31 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"