I have a looping formula in the Amort Tab. Cell F35, L35, M35, B36 and R36.
The whole page was working fine until 2 days ago. I don't know what I did as technically the formulas are all copied from the one above it.
I'm trying to connect real time data (Tab Final) with the Amortization schedule in real time so it is always up to date. And because of the interest setup with the bank I have to calculate in per day (Amort Columns P, Q, R and S) then charge it at the end of the month and even then it varies with the bank. Hence Amort Column M which should = Final Column I. I do think the loop has something to do with Amort Column M but it works in Cells M22, M25, M28 and M31 so I don't know why it doesn't work further down the column.
Bookmarks