Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

generationxwing

macrumors 6502
Original poster
Feb 10, 2005
268
0
Calgary
So I've decided to use Numbers to make up a household budget. No templates that I've found online really do what I want, so I've decided to make my own. I'd like to do something that I saw in another template: drop down selections. I just have no idea how to do that.

What I want is to have two tables: one showing total expenses according to category, and another to input individual line items. With each of those line items, I want to have a drop down menu where I can select what category that expense belongs to, and then the total on the other table will show the sum of any lines that selected that category.

Any idea how I can do this? I'd appreciate any help.

Thanks!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.