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

Posted on Feb 7, 2025 9:22 PM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I create a dynamic budget sheet in Apple Numbers based on selected month

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.