Help Simplify Long Select Case with If/Then

Hi

Didn't test this, but you could do something like

Please Login or Register  to view this content.

This will replace the entire PlayerStat code.

Some comments
1) Do not use cell as a variable as it is a reserved word in VBA. I've cut it down to ce
2) I've used the find statement to find the appearance of the player in the range being evaluated for the current week, in the output range. - variable findit
3) I then use the offset from that range variable to perform the updates
4) In the first block, it updates the column J result
5) In the second block, it uses the competitor SL value as the basis for the offset. If you look at your outputs, it is a function of the SL value by 2 to determine the Total column, and the same function minus 1 to get the Win column for that SL value.
6) Another way to determine the output columns would have been to use match of the SL value against Standings!15:15.

HTH

rylo

I understand the majority of the logic here, and it's right in line with what i was originally thinking however, i'm having issues getting the points Sheets("Standings").Range("J4:J11") {findit.Offset(0,6) <-- which actually needs to be findit.Offset(0,7)}

Please Login or Register  to view this content.

So what i need to have happen is
findit.Offset(0,7) to increase by the value of ce.offset(0,4) only when
ce.Offset(0,3) .Value= "W"

nevermind Gents. I figured it out,
I threw an if statement in as follows:

Please Login or Register  to view this content.