Forum Discussion
Viral TikTok expense tracker for excel and microsoft forms
Riny_van_Eekelen find the excel attached.
I understand the easier way is to create a pivot table from the original table, however, what I am looking to do is that it also marks when I go over budget, the categories on which I spend more/less, and overall to end up with an easy form that I just have to fill in and a formula that will do the rest for me. (like in the video)
If all of this is possible with a pivot table I am open to suggestions.
Thanks.
JRS
JRuedaSam Have a look at the attached. In Sheet1, I added a pivot table. It doesn't look much now, because the data only has two items in it and all for January. But if you expand the data table the pivot table will expand with it. Just press Data / Refresh after adding expenses. And if you add budget info as well, you can create something that could work for you. But it might not look the same as what you have now.