JBone
10-18-2018, 06:25 PM
Good evening. I'm brushing up on my VBA skills and I'm trying some more advanced coding. I'm trying one from a long time ago and I cannot make it work. Here's the issue:
Column A are numbers that need to be encrypted. Column B is a VBA output column that requires finding a replacement value for each number in the Column A set by adding 7 to one of the numbers and then finding the remainder after dividing the new value by 10. Once the scrambled values for all four numbers in the set are found, regenerate the numbers to send by swapping the first and third numbers and the second one with the fourth. (Original order of a set of numbers: first, second, third, fourth after encrypted order: encrypted third number, encrypted fourth number, encrypted first number, encrypted second number.
I can't seem to make this work!!! I appreciate any assistance!!
23065
Column A are numbers that need to be encrypted. Column B is a VBA output column that requires finding a replacement value for each number in the Column A set by adding 7 to one of the numbers and then finding the remainder after dividing the new value by 10. Once the scrambled values for all four numbers in the set are found, regenerate the numbers to send by swapping the first and third numbers and the second one with the fourth. (Original order of a set of numbers: first, second, third, fourth after encrypted order: encrypted third number, encrypted fourth number, encrypted first number, encrypted second number.
I can't seem to make this work!!! I appreciate any assistance!!
23065