Only Sort Cells if Cell Values are Greater than 0

I am working on a Golf League score sheet, and each week there may be a different amount of players that play. I have a weekly worksheet (attached) that contains the full list of golfers that had played that week and I only want to sort the columns for those golfers who have a score greater than 0 (this would be the ones who played that week). You can see that in week 1 I had more players than in week 2. So in my weekly worksheet I sort these sub grids by Score first. However I ONLY want to sort the rows that have a score greater than 0. Can this be done in VBA or am I stuck doing this manually every week?

Week1.PNG
Week2.PNG

Are you just saying that you want the 0's at the bottom? It looks like youre not sorting on anything in particular, this is just a search descending will give you what you want but the scores desceding?

You could do it with a simple sort descending on the full table, this will give you what you want with the top score down and all the 0's at the bottom.

Then you'll need to find the first 0, so Application.WorksheetFunction.Match("0",range("a:a"),false) and pass this to a row number variable.

You can then use, row 1 to row 1st 0 and then do sorting on the other fields.

So you say, have 25 players, 5 didnt golf

1st Operation sort all 25 rows descending by score.

2nd Operation, find the 1st 0, row 21

3rd Operation, sort on range A1:A21, what every you want.

You could just add a column and sort on that:

=if(score<>0, score, 999)

If you're planning to use code, as it appears, then you can do it in code, and clear the helper formula when you're done.