How do I create a dynamic budget sheet in Apple Numbers based on selected month
I am wanting to make a budget sheet that is on one sheet and it changes the listed info that I have in my categories, spending, income etc... depending on the month I select. Is there a way to do this?
So I know I can make 1 header of the table A1 my months (as a drop-down-box) and the whole column can be automated to see that change and all say number 1 (which is January). 2 = February, 3 is March...
Now, to let the rest of the rows update on the month it is either a formula or a text of information. It can't be both. So this is where I get stuck. Unless I have to make a separate table that holds all the information that pulls each month? Anyways, it just stays the same on the rest of the rows. Just unsure what else to add.
[Re-Titled by Moderator]
Mac mini, macOS 15.3