SOLVED

Excel Calender worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2960868%22%20slang%3D%22en-US%22%3EExcel%20Calender%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2960868%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20need%20help%20on%20blocking%20the%20data%20from%20the%20January%20calendar%20(drop%20down%20list)%20to%20the%20next%20months.%3C%2FP%3E%3CP%3EI%20want%20to%20put%20the%20amount%20of%20money%20I%20am%20spending%20per%20day%20each%20month%2C%20but%20when%20I%20type%20a%20number%20on%20a%20month%20it%20carries%20the%20exact%20information%20to%20the%20following%20months.%20The%20numbers%20to%20the%20calendar%20change%20so%20I'm%20sure%20its%20possible%20but%20I%20am%20not%20aware%20of%20how%20to%20do%20this.%20Your%20help%20is%20greatly%20appreciated.%20Thank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2960868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2960905%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Calender%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2960905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1217204%22%20target%3D%22_blank%22%3E%40JennyRae87%3C%2FA%3E%26nbsp%3B%22%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3Ethe%3C%2FSTRONG%3E%3C%2FFONT%3E%20Excel%20calendar%20template%22.%20Which%20one%3F%20There%20are%20many%20different%20ones%20available.%20Can%20you%20upload%20the%20template%20you%20are%20using%20with%20som%20fake%20data%20in%20it%2C%20demonstrating%20what%20you%20are%20trying%20to%20do%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2961679%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Calender%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2961679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2961689%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Calender%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2961689%22%20slang%3D%22en-US%22%3EI%20want%20to%20keep%20track%20the%20amount%20of%20money%20I%20have%20been%20spending%20per%20day%2C%20but%20when%20I%20placed%20the%20money%20formulas%20into%20January%2C%20they%20copied%20to%20the%20following%20months.%3C%2FLINGO-BODY%3E
New Contributor

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 each month, but when I type a number on a month it carries the exact information to the following months. The numbers to the calendar change so I'm sure its possible but I am not aware of how to do this. Your help is greatly appreciated. Thank you! 

4 Replies

@JennyRae87 "the Excel calendar template". Which one? There are many different ones available. Can you upload the template you are using with som fake data in it, demonstrating what you are trying to do?

 

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.
best response confirmed by JennyRae87 (New Contributor)
Solution

@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.