deleting rows depending on values on another sheet

hello all.

i am using excel database (see attachemet) to list player games vs one another. In sheet 1 listed in column A and C are players 1 and 2 games (eg A1 vs C1).
On sheet 2 a certain group are allocated points on previous match history. I am looking to write code to delete players games from sheet 1 (delete entire row) depending on points they have on sheet 2. Firstly I want to find the golden points tally that will remove them from games in sheet 1. The golden points tally will calculated by the player that is top of the last quarter of teams (which would be Lucas on 8 points) and i want to add 3 on to this which would bring golden points to 11.. and basically delete anyone, that has 11 points or less in the group, from the games on sheet1.
The results of the script would be that games involving Loren, Margarett, Lynn, Luciano, Lucas, Erwin, Derek, and Davina should all be deleted from sheet 1 because they have only 11 or less points.
Anyone assist with this? Thanks.

Will there always be 20 players in column A on sheet 2 or can this number vary?

Ok. that way of removing matches is not going to work. i need to do it another way. On the attached workbook (player games2) there is a list of matches in sheet1. In sheet 2 is the table.
I am looking for a way to cycle through all the games in sheet1 and remove the games if the players are side by side in the table.
for eg.. Abraham Vs Zack match should be removed because they are 6th and 7th.
And Alfonso Vs Jolanda match should be removed because they are 4th and 3rd. any ideas?
Player games2.xlsx

Super stuff Robert. Trying to make a few additions to it. I have added ad-hoc games to the sheet 1 with different players names that are not in the league table and these get an #N/A beside them too and end up getting deleted... i presume its because they are not found on the league table?

I have added the line of code thats bolded below and it seems to do the trick..

Please Login or Register  to view this content.

Top stuff. Thanks again.

Hey Robert,

Trying to run the code of every worksheet in the workbook.. is it possible to use ws in the code like below..? is it not working for me.
I have everything set up correctly for the ws but dont know how to use it in a formula.

Original:

Please Login or Register  to view this content.

Edited with ws:

Please Login or Register  to view this content.

Originally Posted by ghynes

Hey Robert,

Trying to run the code of every worksheet in the workbook.. is it possible to use ws in the code like below..? is it not working for me.
I have everything set up correctly for the ws but dont know how to use it in a formula.

Original:

Please Login or Register  to view this content.

Edited with ws:

Please Login or Register  to view this content.

I managed to get this sorted by declaring sheetname as string and using it that way.

Have yet another addition I want to make to the macro and wondering the best way to do it! With the player games2 file above.. I am looking to check where the players are in the table points wise, and if the players are 10 or less points away from one another, the game must be removed from sheet1. for eg... Abraham Vs Zack must be removed because they are separated by 1 point, Alfonso Vs Jolanda must be removed because they are separated by 10 points, Ali Vs Jonathan must be removed because they are separated by 9 points. Any suggestions?