How to add Categories to Monthly Budget template
How to add Categories to Monthly Budget template so that they populate between Budget and Transactions?
iMac, macOS 10.12
Apple Intelligence is now available on iPhone, iPad, and Mac!
How to add Categories to Monthly Budget template so that they populate between Budget and Transactions?
iMac, macOS 10.12
Do you mean the 'Personal Budget' template?
If so go here and, with C2 selected, edit/add items in the Pop-Up Menu in the panel at the right.:
Once you have the items in C2 Pop-Up Menu the way you like them, select C2, command-c to copy, select all cells in column C from C2 down, and command-v to paste. The will place the revised Pop-Up Menu in all the body cells of that column.
Then go here and enter names under Category in column A that exactly match the items you have in the Pop-Up Menu that you just revised. Make sure the spelling is exactly the same, with no extra spaces, etc. If you added categories in the Pop-Up Menu in the Transactions table just add new rows to match them in the Summary by Category table.
SG
Do you mean the 'Personal Budget' template?
If so go here and, with C2 selected, edit/add items in the Pop-Up Menu in the panel at the right.:
Once you have the items in C2 Pop-Up Menu the way you like them, select C2, command-c to copy, select all cells in column C from C2 down, and command-v to paste. The will place the revised Pop-Up Menu in all the body cells of that column.
Then go here and enter names under Category in column A that exactly match the items you have in the Pop-Up Menu that you just revised. Make sure the spelling is exactly the same, with no extra spaces, etc. If you added categories in the Pop-Up Menu in the Transactions table just add new rows to match them in the Summary by Category table.
SG
Assuming that you have a column that contains pop-up menu cells listing all categories:
Select the cell in the first unused row of this column.
Delete the contents of this cell, then enter the new category.
Repeat in cells below for more new items.
Select all cells containing pop-up menus and the cells containing new item values for those popup menus,
In the Cell section of the Format Inspector, set the Data format to Pop-up menu.
All selected cells will then contain a copy of th full menu, each set to the value it displayed when the cels were selected.
Regards,
Barry
Thanks SG. One problem I have is when I go to the first empty space in the pop up, at the bottom of the list, and hit the + it inserts a blank row above it. For instance the last item in the template is "other". I highlight the blank row below "other" and hit the + symbol. Once I hit the + it adds a blank row under "other" then my added category "insurance". Is there a step that I have missed?
Bullmoose66
OK I figured out what was going on. The template has a blank line below other so I hit the - to remove the blank line. I am going to see if I can successfully finish this now. Thanks again!
Bullmoose66
Alrighty this works. I cannot thank you enough for giving me the step-by-step, with the images, to get this done successfully. I have tried for 2 years to get this to work with other people trying to help here on discussions. You are a good teacher by using the step-by-step approach and including the images. Please keep up the good work.
Bullmoose66
Thanks for the kind words, and the green check! Glad it worked out for you. As you've discovered, at first it's not an obvious procedure. But once you know how to do it it's not hard.
SG
How to add Categories to Monthly Budget template