Forming a Static Chronological Monthly Record Via Input of Dynamic Daily Expenses.
So I want to create a daily expense tracker and have it so it tally’s it over the course of a month. Since there may not be any expenses recorded for particular days, the listing on Sheet #2 should exclude those days where there aren’t any expenses. However, for those days where expenses *are* recorded, the days should populate the tables in chronological order.
I have a hunch that it’s either undoable or will take a tremendous amount of effort to accomplish using only the Numbers spreadsheet. An example of what I’m attempting to do is shown below.
As noted in the example, there will be two (2) sheets. Sheet #1 will be the “Input Sheet” that contains a single table where the data is entered. As the data (and the date entered) changes, the tables that are set up on Sheet #2 (The Printable Output Sheet) need to populate accordingly (and hopefully in chronological order) as shown in the example.
Admittedly, the easiest method would be to simply exclude Sheet #1 and just enter the data into each of the tables on Sheet #2.
I was hoping to “appify” the process where a user will enter the data on the first sheet and have a record of that data placed on the second sheet. At the end of each month a the individual can simply print Sheet #2 and submit it.
Since my last request for assistance was answered and addressed so quickly and effectively, I thought I might give it a try. If it’s too much work that isn’t worth the effort, then post that and I’ll lock the thread. Thanks again to all the experts in advance! 🙂
[Edited by Moderator]
MacBook Pro 13″, macOS 15.7
