Way to Concatonate cells in a row based on the order they were entered?
I created a keypad (similar to a phone or ATM numbers 0-9). When you
click on a number key, that key populates a matrix (via macro) similar
to:
All Numbers Numbers Clicked
0
1
2 1
3 1
4 1
5 1
6
7
8
9
In the example above, the keys 4,3,2,5 were entered and a 1 was entered
in the row next to the key number.
I then was able to get the data into a table similar to:
0 1 2 3 4 5 6 7 8 9
2 3 5 8
The top row is all of the numbers and the bottom row is the numbers
that were clicked. I was going to just concatonate the bottom row
2,3,5,8 but the numbers were not entered in that order; instead, the
pin they entered was 4,3,2,5
I am stumped! Any help would be greatly appreciated as I have been
working on this for days.
|