Forum Discussion

JennyRae87's avatar
JennyRae87
Copper Contributor
Nov 12, 2021
Solved

Excel Calender worksheet

Hi! I'm using the Excel calendar template but I need help on blocking the data from the January calendar (drop down list) to the next months. I want to put the amount of money I am spending per day ...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 13, 2021

    JennyRae87 Oh my! I understand what you want to do, but not why you use a calendar template for it.  Templates like these are often quite useless, even for the purpose they where designed for. And they are most definitely not designed to keep track of a budget. Wouldn't really know where to begin analysing the workbook to find where it goes wrong.

     

    Consider a totally different approach. Create structured table where you enter all your expenses as they occur (Date, Amount, Description) and then create a pivot table to summarise the expenses.

JennyRae87's avatar
JennyRae87
Copper Contributor
Nov 13, 2021
I want to keep track the amount of money I have been spending per day, but when I placed the money formulas into January, they copied to the following months.
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 13, 2021

JennyRae87 Oh my! I understand what you want to do, but not why you use a calendar template for it.  Templates like these are often quite useless, even for the purpose they where designed for. And they are most definitely not designed to keep track of a budget. Wouldn't really know where to begin analysing the workbook to find where it goes wrong.

 

Consider a totally different approach. Create structured table where you enter all your expenses as they occur (Date, Amount, Description) and then create a pivot table to summarise the expenses.

Resources