This is a useful macro to use the previous rows cell for current rows calculation.
For example, if we are to use last months closing balance (previous row) as this months (this rows) opening balance use this macro. This is great for an amortization schedule.