Attach an example workbook. Images are no use .
Also, why copy cells individually?
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