Forum Discussion
Add value to another cell in other sheet when choosing from dropdown list
Hello everyone 🙂 I am trying to create my own budget scheme to keep track of my finances. I have an idea of how I want it but do not have the right competences to implement it. Will try to mak...
I'm also curious if you can invent a formula that can retain a value once calculated (e.g. capture a number from "Overview" to "Budget" sheets when the year and month match while the number remains once TODAY() is past those year and month). VBA should be able to handle the requirement, but I'm not certain that using formulas only is viable.
There's one workaround I could think of: Enable iterative calculation in Formulas Excel options will let you use circular reference, thus the formulas under each month in "Budget" sheet can be something like below.
=IF(YEAR(overview_date)&MONTH(overview_date)&overview_category=YEAR(budget_date)&MONTH(budget_date)&budget_category,overview_data,self_referencing_cell)
See attached file. I checked it works, but I have no idea how detrimental the consequences of letting circular references can be. Hope Excel gurus provide us with better solutions.