Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Deleting rows: another question (Excel 2003 on XP)

    I've seen a number of posts here about deleting rows based on various information, but I have no VBA or any other programming experience, so I don't know how to adapt macros to do something slightly different. And I'm trying to help someone who knows even less than I do. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    We get a number of reports downloaded from a Sequel database; the reports contain way too much data, but we can't (mostly for bureaucratic reasons) narrow the queries any further. So what I need to do is this: I have a list of words and phrases I would like to search for. If certain word(s) are found in certain column(s), I would like to automatically delete the row.

    I've attached a sample file to explain it more clearly. I'm sure it'll be child's play for the experts here.

    Thanks,

    lind <img src=/S/shy.gif border=0 alt=shy width=15 height=15>
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Deleting rows: another question (Excel 2003 on XP)

    I'd put the lists of words to search for on a separate sheet, and organize them in columns at the top of the sheet, with the column they should apply to in the first row.
    The sheet with the imported data should contain no other information.
    You can then use the macro in the attached workbook. I have added lots of comments in the code.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Location
    St. Louis, Missouri, USA
    Posts
    67
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Deleting rows: another question (Excel 2003 on XP)

    Thanks, Hans!!

    This seems to be just what I need!!

    lind <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

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