please, chosen 4 digits * decrease by 9999 and add by * 9999.

[jack]

please, chosen 4 digits
* decrease by 9999 and add by
* 9999
the leftovers left the macro does not consider
* only the last 4 digits
* I'll put lots of draws the macro has to do automatic
http://www.mediafire.com/file/j2h5wqrd1a3uoo1/somar_e_diminuir.xlsx/file

 

[jack]

No need for macros. In F6:
=ABS(9-A6)
then drag across to I6 and then drag down to I10.

In K6:
=MOD(INT(($A6*1000+$B6*100+$C6*10+$D6+9999)/10^(4-COLUMN(A:A))),10)
then drag across to N6 and then drag down to N10.
***************