Results 1 to 3 of 3

Thread: search for data and delete rows containing it

  1. #1
    Junior Member
    Join Date
    Feb 2014
    Posts
    1
    Rep Power
    0

    search for data and delete rows containing it

    I have an Excel workbook with 24 sheets of data. The first sheet contains data in Column A that is bad data that needs to be deleted from all the other worksheets.

    I will call the first worksheet with the bad data (1500 rows) "bad data"

    Would like to record a macro that looks at data in A1 cell of "bad data" worksheet, finds matching data in all other worksheets, deletes that entire row of data, then also deletes the bad data in the original worksheet "bad data".

    After delete row A in "bad data" worksheet, the bad data that WAS in A2 moves up to A1. would like to run the macro again using the new bad data that has been moved up to A1 as a result of previous deletions.

    Or run a macro that looks up all data from column A in the first worksheet (1500 rows) and deletes all rows with matching data in the other 24 sheets.

    The data is bad emails that i am deleting from my .csv email database file.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Can you upload a sample file with the 'bad data' sheet tab, and a couple of sheets where you want it deleted from.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    RickStewart,

    You have to tell as if you ask same question in other forums.

    search for data and delete rows containing it

    There have been answered from XLD, but you did not even reply....
    Last edited by Ingolf; 02-24-2014 at 09:16 PM.

Similar Threads

  1. Delete blank rows
    By dhivya.enjoy in forum Excel Help
    Replies: 5
    Last Post: 10-23-2013, 10:04 PM
  2. Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  3. Replies: 5
    Last Post: 07-11-2013, 07:31 AM
  4. Delete Rows
    By ayazgreat in forum Excel Help
    Replies: 2
    Last Post: 12-13-2012, 11:48 AM
  5. Replies: 2
    Last Post: 11-17-2011, 07:49 PM

Posting Permissions

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