Forum Discussion
Categories & Sub-Categories
Jaspyroman See attached. Fixed it for you. This particular template uses Data validation with INDIRECT references to structured tables. More about INDIRECT in the link below.
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261
The trick is that you need to create a a structured table for the new sub-category. The name of the new table should be exactly the sames as the name of the main category, but it may NOT contain spaces.
More about structured Excel tables in the link below.
So, I renamed the Main category to "OfficeSupplies" (without the space) and the list with sub-categories on sheet "C" in column L is now a structured table called "OfficeSupplies".
Jaspyroman See attached. Fixed it for you. This particular template uses Data validation with INDIRECT references to structured tables. More about INDIRECT in the link below.
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261
The trick is that you need to create a a structured table for the new sub-category. The name of the new table should be exactly the sames as the name of the main category, but it may NOT contain spaces.
More about structured Excel tables in the link below.
So, I renamed the Main category to "OfficeSupplies" (without the space) and the list with sub-categories on sheet "C" in column L is now a structured table called "OfficeSupplies".
