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?

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?

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

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?