Forum Discussion
Viral TikTok expense tracker for excel and microsoft forms
JRuedaSam The link isn't very useful as I can't edit or download it. Can you upload it here?
Your template looks very colourful, but if you can accept another format/lay-out, why not look into creating a pivot table on the basis of the expense table? No complicated formulae needed.
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.
