When I select a year other than 2019 in the Setup sheet the formulas in the Monthly Analysis sheet get messed up. Can someone please figure out what is wrong?
Hello, How can the total "actual" amounts be inserted on the Budget sheet from the 'Transactions' sheet by Category and date to fall in the proper months? I highlighted yellow the amounts, category, and dates in the Transactions sheet. I put what should be the amounts for the month of January...
Hi, On my Monthly Analysis sheet I filled the amounts manually in columns C & D. Can there be formulas to get these amounts from the Budget sheet based on the selected month in cell H4? Thank you
Hi, On my Monthly Analysis sheet I would like the days of the calendar to automatically fill based on cells H2 and H4. Is this possible to do? Thank you very much
Hello, I have an Appointments sheet for one time, monthly recurring, and yearly recurring events. Can these be auto filled on the appropriate calendar sheets please? The one time will not occur again, the monthly will be the same day each month, and the yearly will be on the same day each...
chandoo.org
Do any of those threads has Your the latest file ... which will 'mess up' as You've written.
It looks like I can attach the file now. The only year that works on the Monthly Analysis sheet is 2019. Other years give errors on the formulas in columns C:E
Tech56
Did You read my question?
... as You could check that ... N/A given formula You could see that IF NO 2020-year Budget cannot find from Budget-sheet
then ... what else would be there without any Error-handling?
Oh I see that now. The headings are set to 1/1/2019 for January on the Budget sheet for instance. Maybe the logic is wrong so it can be adapted for other years.
Tech56
... hmm? ... hmm? ... really?
Okay, You asked ...
Is this 4th or 5th step with Your same file?
Suggestion:
You should have a Master plan or at least a plan
... what do You would like to have after all needed has done?
Who else could figure .... what?
Tech56
Your: I am trying to develop this budget workbook for starting of new year.
You try to develop by asking (that's good)
... but do other really know the Master Plan?
You ask to do some parts of Your budget workbook
... do everyone have time to find out ... if modify this part - do it effect or affect to other parts?
or
do You have idea or 'one second' time - what would some modifications effect or affect?
eg if change that 2019 to 2020 in cell H4 ... Excel works as well as possible, but ...
> As I tried to write: Please, sit down, take some breaths and make a Master Plan. It would help You!