![]() ![]() This method is for when you only need to have only a few of these category-subcategory dropdown lists on the sheet. Once this is done, we are all set up and can proceed with either Method 1 or Method 2! Note - the named ranges don’t need to be on the same sheet as your drop-down lists, and I usually keep a separate sheet just for containing all the named ranges in a workbook. This is why we needed to put restrictions on the primary category names. Once you have finished, you now need to create a new named range for each of these parent categories, using the primary category name as the title. Next, for each parent category, make a new column and list all of the subcategories that belong to it. If you want to have a primary category that has two or more words, you can use some tricks like inserting an underscore between the two words. Something to keep in mind here is that for each of the category names, we can’t have any spaces, special characters, lead with a number or “TRUE” or “FALSE”. You will then save this as a named range, with the title “Categories” or whatever makes sense to you. ![]() For both methods, you will need to create a column with all of the primary categories. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |