Add 1234 automatically

[Jack-P-Winner]

I would like to be able to place the digits in cells 5YZ AA AB, 5AE AF AG AH
5AK AL AM AN, 5AQ AR AS AT and have the formula or MACRO run it to the end
which would be in row 25

You keep adding 1234 to the new number until it gets back to the original number
like the 6520 in row YZ ZZ ZB and the 6520 row 25 YZ ZZ ZB

I would like to be able to place the digits in cells 5VWX, 5AA AB AC
5AF AG AH , 5AJ AK AL and have the formula or MACRO run it to the end
which would be in row 25
You keep adding 123 to the new number until it gets back to the original number
like the 058 in row VWX and the 058 row 25 VWX

 

[Hui]

If V7: =MOD(V6+V5,10)
Copy to all other cells with Black Text
Doesn't that do what you want

 

[Jack-P-Winner]

You are the man Hui!!!!!!! THANK YOU THANK YOU THANK YOU!!!!!!

 

[Hui]

I gave you this solution to a similar question about 3 weeks ago?

 

[Jack-P-Winner]

I remember Hui, I couldn't find it. I have so much going on right now I get overwhelmed. Thanks for your help!