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