+ Reply to Thread
Results 1 to 6 of 6

Delete rows based on value, jump columns, skip a few rows, jump back and resume deleting.

  1. #1
    Registered User
    Join Date
    09-09-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    9

    Delete rows based on value, jump columns, skip a few rows, jump back and resume deleting.

    Hello,

    How can I:
    1. Delete rows starting from the bottom up in the column E until a value in column E is found.
    2. Then jump to column B, stop deleting, continue to look upward for a value in that column.
    3. Then if a value is found in column B, jump back to column E, step one row up and resume deleting until the next value is found in column E.

    Is that too complicated?

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete rows based on value, jump columns, skip a few rows, jump back and resume deleti

    An example workbook showing what should be deleted and what should not be deleted would make it a lot easier to understand.

  3. #3
    Registered User
    Join Date
    09-09-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    9

    Re: Delete rows based on value, jump columns, skip a few rows, jump back and resume deleti

    In this workbook: http://pastebin.com/raw.php?i=4GTSXiv3

    Names that don't have anything in columns D, E, and F have to go. So the names 332, 355, 389, 440, and 446 should be deleted along with the tim underneath. Maybe there's a different logical approach that should be taken, maybe mine isn't the best.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete rows based on value, jump columns, skip a few rows, jump back and resume deleti

    Could you upload the example workbook so we have data to work with

  5. #5
    Registered User
    Join Date
    09-09-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    9

    Re: Delete rows based on value, jump columns, skip a few rows, jump back and resume deleti

    I did, just click the pastebin link in the post above yours. You can easily copy the data to an excel sheet.

    That is the book I currently work with.

  6. #6
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete rows based on value, jump columns, skip a few rows, jump back and resume deleti

    I wish you the best of luck finding a solution to your problem.

+ 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. Jump back and forth between sheets
    By pigpen in forum Excel General
    Replies: 1
    Last Post: 09-05-2014, 01:47 PM
  2. [SOLVED] Jump to a cell and back??
    By ladi100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2013, 05:30 AM
  3. How to jump between Columns and Rows
    By mar_t in forum Excel General
    Replies: 5
    Last Post: 07-28-2010, 11:08 PM
  4. Deleting Rows from 3 sheets back on matching columns
    By motown in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-07-2010, 02:40 PM
  5. Sometimes data will jump rows randomly.
    By Jason in forum Excel General
    Replies: 1
    Last Post: 04-11-2006, 03:35 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