Data Validation: Lists
 

I have a drop down list created column A made of main cetegories. I want to
create a subcategory drop down list in column B based on the main category
selected in column A.

The data for the main categories are in column I. All subcategory lists are
contained in columns J through W with a header from the main category.

How can I establish my subcategory drop down list based on what I choose for
the main category in the previous column, or should I try a different
approach?

Data Validation: Lists
 

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"evoxfan" wrote in message
...
I have a drop down list created column A made of main cetegories. I want
to
create a subcategory drop down list in column B based on the main category
selected in column A.

The data for the main categories are in column I. All subcategory lists
are
contained in columns J through W with a header from the main category.

How can I establish my subcategory drop down list based on what I choose
for
the main category in the previous column, or should I try a different
approach?

Data Validation: Lists
 

This should get you started

http://www.contextures.com/xlDataVal13.html
--
HTH,
Barb Reinhardt



"evoxfan" wrote:

I have a drop down list created column A made of main cetegories. I want to
create a subcategory drop down list in column B based on the main category
selected in column A.

The data for the main categories are in column I. All subcategory lists are
contained in columns J through W with a header from the main category.

How can I establish my subcategory drop down list based on what I choose for
the main category in the previous column, or should I try a different
approach?

Data Validation: Lists
 

Thanks.

"T. Valko" wrote:

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"evoxfan" wrote in message
...
I have a drop down list created column A made of main cetegories. I want
to
create a subcategory drop down list in column B based on the main category
selected in column A.

The data for the main categories are in column I. All subcategory lists
are
contained in columns J through W with a header from the main category.

How can I establish my subcategory drop down list based on what I choose
for
the main category in the previous column, or should I try a different
approach?

Data Validation: Lists
 

Thanks.

"Barb Reinhardt" wrote:

This should get you started

http://www.contextures.com/xlDataVal13.html
--
HTH,
Barb Reinhardt



"evoxfan" wrote:

I have a drop down list created column A made of main cetegories. I want to
create a subcategory drop down list in column B based on the main category
selected in column A.

The data for the main categories are in column I. All subcategory lists are
contained in columns J through W with a header from the main category.

How can I establish my subcategory drop down list based on what I choose for
the main category in the previous column, or should I try a different
approach?

Data Validation: Lists
 

You're welcome!

--
Biff
Microsoft Excel MVP


"evoxfan" wrote in message
...
Thanks.

"T. Valko" wrote:

See this:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"evoxfan" wrote in message
...
I have a drop down list created column A made of main cetegories. I
want
to
create a subcategory drop down list in column B based on the main
category
selected in column A.

The data for the main categories are in column I. All subcategory
lists
are
contained in columns J through W with a header from the main category.

How can I establish my subcategory drop down list based on what I
choose
for
the main category in the previous column, or should I try a different
approach?