This one is a bit complicated but I hope someone knows how to do the VBA to get this done.
Example
Sheet1 - I want the user to type a numeric value into cell A1. Lets say its 12345678 for example.
Sheet2 - I then want this numeric value (12345678) to be broken down by each number and entered into 8 different cells. One cell for each number. So for example, the first number 1 will be transferred to cell A5. Number 2 will go into B5. Number 3 will go into C5 and so forth...
Let me know if this is possible. Any help is appreciated. Thank you.
Example
Sheet1 - I want the user to type a numeric value into cell A1. Lets say its 12345678 for example.
Sheet2 - I then want this numeric value (12345678) to be broken down by each number and entered into 8 different cells. One cell for each number. So for example, the first number 1 will be transferred to cell A5. Number 2 will go into B5. Number 3 will go into C5 and so forth...
Let me know if this is possible. Any help is appreciated. Thank you.