Hi all:
I've got a situation that I hope someone can help me out of.
I have set up a worksheet containing various keywords that I want to use to further define the keywords as to category and then subcategory.
I have placed the category and subcategory data in the same workbook, albeit on separate worksheets.
I have been successful in generating lists for the category data and the subcategory data.
I have also been successful in creating a drop down menu for the 19 different categories, using MS's online help site, and placed that into a column using the Validation>settings function.
This is far as I have gotten, now the difficult bit.
What I want is probably easiest to describe with an example:
In the Column CATEGORY, each cell is set so that when I click on the icon to access the menu of categories, I can then select one.
Now, if I select, say, SPORTS, as the category, then in the cell adjacent to the right in column SUBCATEGORY is then loaded with a drop menu of the subcategories in Sports, e.g., football, basketball, swimming, etc.
I'm guessing it wants to be some sort of if>then statement:
if(value of cell B2="SPORTS") then (C2=list of sports in a drop menu)
Can someone help?
All the best,
Steve
Bookmarks