Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    delete entire rows if... (2000)

    Messaggio cancellato da sal21

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: delete entire rows if... (2000)

    You can use autofilter and not have to create a macro.
    In S3 (S is column outside the data range) enter the formula:
    <pre>=I3<>J3</pre>

    Copy it down the all the rows

    In T3 (T is column outside the data range) enter
    <pre>=and(I3<>j3,K3<>l3)</pre>

    Copy it down the all the rows

    Data- filter - autofilter on your range
    For "Macro1" filter on column s, then delete the visible rows
    For "Macro2" filter on column t, then delete the visible rows

    Steve

Posting Permissions

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