A lot of numbers!
To try and break it down into manageble chunks
I have highlighted what i think are the varibles that you would type in, in blue.
and pretty much everything else will calculate from that? for example i would think that b1 should always be the current year or maybe it should equal the move out date?
Ideally if we can get the years to be dynamic the calculation will work from them and we can hide what we dont want.
In my mind nothing should move as each calc can look for the correct detail
It might be a slow approch but we can get a decent spready at the end of this
|