DAGUET
Member
hello
I currently try to reconcile in a same worksheet a quarterly schedule of cash payments to shareholders and a yearly (annual accounting figures derived from the income statement of a company).
The idea is simple : end of period Dec 31st should coincide and be aligned with December in the cash statements (except that in between, I have march, june, september..., 3 quarters for which I could insert 3 empty columns).
My modeling horizon goes to 2035 and therefore I need an automated process which allows me to keep the formulae intact.
Transpose can' t do the job nor is suited for it.
Any idea to rationalize the solution is welcome!!!!
*
Best Regards
I currently try to reconcile in a same worksheet a quarterly schedule of cash payments to shareholders and a yearly (annual accounting figures derived from the income statement of a company).
The idea is simple : end of period Dec 31st should coincide and be aligned with December in the cash statements (except that in between, I have march, june, september..., 3 quarters for which I could insert 3 empty columns).
My modeling horizon goes to 2035 and therefore I need an automated process which allows me to keep the formulae intact.
Transpose can' t do the job nor is suited for it.
Any idea to rationalize the solution is welcome!!!!
*
Best Regards
