Results 1 to 11 of 11

deleting rows depending on values on another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2005
    Location
    Ireland
    MS-Off Ver
    O365
    Posts
    75

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1