Results 1 to 4 of 4

Loop through Column & delete entire row if Value is found

Threaded View

  1. 10-01-2018, 02:32 PM #1
    lougs7
    lougs7 is offline
    Forum Contributor
    Join Date
    09-23-2015
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    187

    Loop through Column & delete entire row if Value is found

    Hi Guys,

    I have a bunch of data in a spreadsheet (1000's of rows), I want to run a code that will loop through Column AC and if it finds the Cell value = "Spread" or & "Calendar Spread" than to delete the entire row.

    A desensitized spreadsheet is attached for you reference.

    Thank you!
    Last edited by AliGW; 10-27-2018 at 02:39 AM. Reason: Spreadsheet remoived as requested by OP - sensitive data therein.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Found?, then delete entire rows. Not found end sub
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2018, 01:56 PM
  2. delete the entire row until column x if value '2' is found in column J?
    By SHELLY567 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2018, 11:23 PM
  3. [SOLVED] delete entire row when value is found
    By 9599lorenzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2015, 03:06 AM
  4. [SOLVED] Delete Entire Row if Blank is Found in Column
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-17-2014, 11:28 PM
  5. delete the entire row if duplicate found in column
    By gujugolf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2013, 04:07 PM
  6. delete entire row if 'value' found anywhere in column - most efficient way?
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-25-2012, 08:21 AM
  7. Need to compare 1 row in two worksheets and delete entire column if a match not found
    By jasondu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-24-2012, 09:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1