Forum Discussion
Categories & Sub-Categories
I downloaded a daily expense template online and i'm trying to modify it for my use. I added a new column for sub-categories (office supplies) but cannot get it show on the expense capture sheet. How can I do this, cos I need to be able to periodically update it.
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".
2 Replies
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".
- That's great Riny_van_Eekelen. Thanks so much. I will keep in touch please, if you don't mind.
