zbor's solutions is the one to go with. Mine will work, but his is simpler and better.

If your original number has to be in a1 then in B2 put =MOD(A1+6,43) and then in B3 put =MOD(B2+6,43) and then drag it down as necessary.