Forum Discussion
Start building your Microsoft Ignite schedule today
I have 4 investment properties, each has an amortizing loan. I put an amortization schedule on each of 4 tabs in my workbook. On another tab I in the same workbook I have created a financial statemen...
Yes there is.
However to keep is easy to support I would set up a hidden cell
the hidden cell would hold the offset like =MONTH(NOW())+YEAR(NOW())*12 -24000 (Adjust as needed)
then the cell reference =INDEX(D5:E12,K5,1)
However to keep is easy to support I would set up a hidden cell
the hidden cell would hold the offset like =MONTH(NOW())+YEAR(NOW())*12 -24000 (Adjust as needed)
then the cell reference =INDEX(D5:E12,K5,1)