Nov 01 2021 04:37 PM
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.
Nov 01 2021 10:17 PM
Solution@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".
Nov 02 2021 12:31 AM
Nov 01 2021 10:17 PM
Solution@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".