Posts by Mikemelon

    Hi Roy,


    I have attached the example worksheet.

    The tab to use is "loan", I need the numbers in the cells (B5:M14) in pink to be close to 0, in order for this to happen you have to input the reciprocal positive value in the yellow cells (B18:M27), when you enter a number the next cell changes as it is affected by interest, hence the reason I need it to do it one cell at a time. I know you can use the macro recorder to do it but there are other equations and if statements that I need to include that cannot be used with the macro recorder

    Hope this makes sense


    Regards

    Mike

    Files

    • Example 1.xlsm

      (531.13 kB, downloaded 58 times, last: )