+ Reply to Thread
Results 1 to 5 of 5

Find then Delete rows from multiple sheets?

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    23

    Find then Delete rows from multiple sheets?

    Hello!

    I need a way to locate a code (ie: AV8032) in several separate excel worksheets and then delete the entire row from each of them.

    For example it would find and delete this row (not the headers of course):

    Item Description ID Link Color Weight
    Shoes Brand X AV8032 www.abc.com Black 1.09

    The headers in each file are different (ID may be SKU in another file)

    Also I DON'T want it to delete something like TAV8032 or AV80329.

    Thanks in advance!
    Last edited by gronnies; 11-19-2010 at 04:16 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Find then Delete rows from multiple sheets?

    Hello gronnies,

    Can you clarify these contradicting statements...
    I need a way to locate a code (ie: AV8032) in several separate excel worksheets and then delete the entire row from each of them.

    Also I DON'T want it to delete something like TAV8032 or AV80329.

  3. #3
    Registered User
    Join Date
    10-22-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Find then Delete rows from multiple sheets?

    Oh sorry - I meant that I want to be sure it only deletes the cell that says AV8032 exactly - nothing before or after it.

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

    Re: Find then Delete rows from multiple sheets?

    Hello groonies,

    I think you mean that you want to delete the whole row which contains AV8032 exactly. Also, It will need to be done on different sheets where AV8032 can be located in many different rows and columns. If this is true then this code should work for you. TRY ON A COPY OF YOUR WORKBOOK.
    Please Login or Register  to view this content.
    Let me know if it works. Also in the future you may want to look at posting your questions on a different forum. The napoleon complex of the moderators around here is quite appaling. They are way more concerned about you following all 150 of their rules to the "T" rather than helping those in need. Either way let me know if it helps. Oh btw moderator can i please get another infraction for helping someone?

  5. #5
    Registered User
    Join Date
    10-22-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    23

    Re: Find then Delete rows from multiple sheets?

    THANK YOU! I will try it when I get back home

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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