| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation lists help? | Excel Worksheet Functions | |||
| Data Validation - Using 2 Lists | Excel Discussion (Misc queries) | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| Data Validation Lists | Links and Linking in Excel | |||
Linear Mode
