Hi there,
I just discovered this Forum and so far I couldn't find any solution via the search. I have a problem that most likely should be easily solved but I am pretty new to Excel.
Problem:
I downloaded some household budget file and modified it to make it more detailed. Now the File looks like this:
Sheet1: overview (gets all data from sheet 2)
Sheet2: monthly expenses (manually input & gets data from sheet 3)
Sheet3: daily expenses
Sheet4&5, 6&7,... = next month
The overview is currently showing the data for the first month, which works perfectly fine. However I would like to add some button or slider or anything similar that allows me to select another month (so instead of sheet 2, it should be sheet 4).
Right now the overview sheet uses about 10 formulas like: =SUMIF(BudgetDetails[Category],[@Category],BudgetDetails[Projected Cost])
I will rename Budgetdetails to "January" and the new function should simple be able to change the "budgetdetails" to "january" (and later February respectively, by a simple click or slide).
Is there any easy solution in doing so? Button? Slider? Macro?
Do you have any other ideas?
I could upload the empty file if it's helpful (sorry for my English)
Bookmarks