Results 1 to 13 of 13

Loop to Delete Entire.Rows if conditions are met

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2018
    Location
    Netherlands
    MS-Off Ver
    Office 13
    Posts
    30

    Loop to Delete Entire.Rows if conditions are met

    Hi

    I am looking for a way to delete Entire.Rows in excel if certain conditions are met. I have tried writting code but seeing as I am moderate this one is a little too advanced for me, a sample spreadsheet is attached for your reference.

    The conditions is:
    If any particuliar Row has the same Price (column M) & same Billing Account (Column J) & same Contract (column AA) as another row [/I] THEN simply delete the Entire Row where there is text found in Column AC

    It may sound complicated, but with the sample spreadsheet it is easy to follow. Basically I am trying to delete the dup that occurs, I am dealing with thousands of rows of data so can't manually do this.

    To sum up:
    If a Particular Client has a case where the Account & Price & Contract are the same, I need one of the lines deleted, the line that would be deleted is the one with text found in AC. I originally had a macro to delete all rows with text in AC, but it was deleting stuff that wasn't dups, this is why I need to encorprate these conditions.

    In my sample spreadsheet I highlighted in blue where this situation would happen, and if I were to run a macro it should only delete 2 lines, one from each case. ** in real spreadsheet rows where this dups appears may not neccesarily be adjacent to each other

    This is a little too advanced for me, I will take whatever help I get and learn off you for next time. Greatly appreciate anyone helping me out.

    Have a bless day.
    Attached Files Attached Files
    Last edited by stein7; 11-28-2018 at 09:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop through Column & delete entire row if Value is found
    By lougs7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2018, 02:56 PM
  2. [SOLVED] Delete Entire rows without loop with multiple partial strings criteria
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2018, 12:05 PM
  3. [SOLVED] Help combining macros to delete rows on conditions and add data into cells on conditions
    By JayJayGC in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-03-2017, 10:14 AM
  4. [SOLVED] Copying and Pasting entire rows on conditions
    By Nuccio92 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2015, 02:01 PM
  5. Delete entire rows
    By Solberto in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-06-2015, 02:29 PM
  6. [SOLVED] Loop through worksheet add and delete row with conditions
    By Hyperdude in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-09-2012, 12:05 AM
  7. Macro to select 4 entire rows and then delete rows
    By Scott Viney in forum Excel General
    Replies: 3
    Last Post: 09-22-2005, 03:05 PM

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