P
Paul
Hi,
I'm nearing the end of a project (an email game) and i would like to
have the sheet keep scores.
So far, I have 2,3,4 players and these are represented by columns B,C
or B,C,D or B,C,D,E. (depending on which you select.) Player 1 takes
their turn for example, clicks a button and the sheet is saved and
sent to the other players. This also inputs the score into Column G:
with a 1 next to it. Player 2 takes their turn, this score is also
placed in column G: beneath player 1's and a 2 next to it as below:
(if there are 3 players column E reads 123, 123 etc.)
E G
1 23
2 14
1 21
2 11
1 33
I was looking for a way to (move) sort? this list into the columns B:C
as below:
B C
23 14
21 11
33
Any help with this would be appreciated. Ideally I would like to use a
piece of vb code that i could paste into the code before the save and
send part.
Paul
I'm nearing the end of a project (an email game) and i would like to
have the sheet keep scores.
So far, I have 2,3,4 players and these are represented by columns B,C
or B,C,D or B,C,D,E. (depending on which you select.) Player 1 takes
their turn for example, clicks a button and the sheet is saved and
sent to the other players. This also inputs the score into Column G:
with a 1 next to it. Player 2 takes their turn, this score is also
placed in column G: beneath player 1's and a 2 next to it as below:
(if there are 3 players column E reads 123, 123 etc.)
E G
1 23
2 14
1 21
2 11
1 33
I was looking for a way to (move) sort? this list into the columns B:C
as below:
B C
23 14
21 11
33
Any help with this would be appreciated. Ideally I would like to use a
piece of vb code that i could paste into the code before the save and
send part.
Paul