+ Reply to Thread
Results 1 to 3 of 3

Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E

  1. #1
    Registered User
    Join Date
    03-13-2016
    Location
    Belfast
    MS-Off Ver
    2013
    Posts
    1

    Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E

    Hi Everyone,

    I need a macro that deletes all rows below a certain criteria in column A. So when the term Technology appears I need every row below this word to be deleted.

    Following this I need a macro to delete any rows in Column E that contain the term 0 Days.

    I tried the following for the first issue but it doesnt seem to work for me? I am a novice to macro coding, so any help is greatly appreciated.
    Last edited by LennyC91; 03-14-2016 at 06:18 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Delete All Rows Below Criteria in Col A / Then Delete Specific Rows in Col E

    Maybe:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete Rows with specific criteria
    By love2waltz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2015, 11:59 AM
  2. How can I delete rows based on specific criteria using a macro?
    By akouleze in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2011, 02:49 AM
  3. Delete specific rows, creating range and criteria using inputbox
    By gmccray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2008, 02:00 PM
  4. Delete rows based on specific criteria
    By Archana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2007, 05:00 AM
  5. [SOLVED] Delete rows if specific criteria not met.
    By SITCFanTN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2006, 07:25 PM
  6. Delete rows that do not meet specific criteria
    By SITCFanTN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2006, 11:36 AM
  7. [SOLVED] I want to delete certain rows based on specific criteria
    By Alaphas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2005, 07:06 PM

Tags for this Thread

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