|Have you thought about using a User Form with just one field|
then have VBA split apart the data, since you want to post the data to
another sheet anyways?
With the User Form, I don't know how difficult it would be to split the data apart
and place it into the cells you want, but DerbyDad03 would probably have a better
understand of it then me.
Here is a link for creating a User Form:
Also, this is a partial solution using a formula.
You enter your 9 digits into cell A1
In cell C1 enter the formula: =MID($A$1,ROW(),1)
drag down 8 rows and C1 thru C9 should have a single digit
Now all you will need to do is create some VBA to move the data
from C1 thru C9 to your second screen and zero out cell A1
and attach it to a button.
message edited by mmcconaghy