Need macro to do following:-
I have loan a/c which is outstanding amounts as 153408 and installment amount as 3196.The due date if 10 of each month starting 10/05/1998.I want to make a macro to change his outstanding balance at 10 of each month.for example 10/05 become 150212 and remain same till 9/6 on 10/6 it become 147016 and change accordingly on each month.
Also from 10/05 to 09/06 it sholuld fill the cell in column with same amount of 150212.and from 10/06 to 09/07 with 147016.Please if any one could help.Regards,
I have loan a/c which is outstanding amounts as 153408 and installment amount as 3196.The due date if 10 of each month starting 10/05/1998.I want to make a macro to change his outstanding balance at 10 of each month.for example 10/05 become 150212 and remain same till 9/6 on 10/6 it become 147016 and change accordingly on each month.
Also from 10/05 to 09/06 it sholuld fill the cell in column with same amount of 150212.and from 10/06 to 09/07 with 147016.Please if any one could help.Regards,