Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Create new drop down from previous drop down selection

I have a worksheet where the 1st column is the Region and the 2nd column is
the sub-banner(areas within the region). I have created a drop down on the
first column where you can select the region. Is there a way to create a
drop down in the 2nd column where it only shows the sub-banners associated
with the region that was selected in column 1 if I have the sub-banners
separated by Region on another worksheet?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Create new drop down from previous drop down selection

See

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


In article ,
Supe wrote:

I have a worksheet where the 1st column is the Region and the 2nd column is
the sub-banner(areas within the region). I have created a drop down on the
first column where you can select the region. Is there a way to create a
drop down in the 2nd column where it only shows the sub-banners associated
with the region that was selected in column 1 if I have the sub-banners
separated by Region on another worksheet?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Create new drop down from previous drop down selection

You can create dependent data validation dropdowns, as described he

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


Supe wrote:
I have a worksheet where the 1st column is the Region and the 2nd column is
the sub-banner(areas within the region). I have created a drop down on the
first column where you can select the region. Is there a way to create a
drop down in the 2nd column where it only shows the sub-banners associated
with the region that was selected in column 1 if I have the sub-banners
separated by Region on another worksheet?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Create new drop down from previous drop down selection

Thanks. That worked.

Now I have another question for you if this is even possible. This form is
for updating items that may or may not be available in all sub-banners in a
region. Is there a way if ALL was on option in the drop down that when
selected it would list all sub-banners on the form on separate lines? For
example if the region had 5 sub-banners, row 1 would list sub-banner 1, row 2
would list sub-banner 2, .... Would save the trouble of having to select
the 5 sub-banners individually on all 5 lines. Might be asking a bit much,
but thought I would see if that's an option. Thanks.


"JE McGimpsey" wrote:

See

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


In article ,
Supe wrote:

I have a worksheet where the 1st column is the Region and the 2nd column is
the sub-banner(areas within the region). I have created a drop down on the
first column where you can select the region. Is there a way to create a
drop down in the 2nd column where it only shows the sub-banners associated
with the region that was selected in column 1 if I have the sub-banners
separated by Region on another worksheet?


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
Create a drop down/pop-up calendar in excel ruthie Excel Discussion (Misc queries) 1 September 21st 06 11:45 AM
Create drop down that will show a range. j91co Excel Worksheet Functions 1 September 7th 06 04:23 PM
Open hidden sheets from a drop down list selection Ant Excel Discussion (Misc queries) 3 October 7th 05 10:01 AM
Drop list affected by previous choice Gaëtan Mongeon Excel Worksheet Functions 2 June 26th 05 01:29 AM
Running code on a drop down selection change Steve Haack Excel Worksheet Functions 1 April 26th 05 05:03 AM


All times are GMT +1. The time now is 03:24 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"