+ Reply to Thread
Results 1 to 2 of 2

Macro to delete entire rows if cell values do not match list/named range.

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    15

    Macro to delete entire rows if cell values do not match list/named range.

    Hello all!

    So, I currently have a worksheet that I'm responsible for filtering out unnecessary data for my team. Here is the setup:

    There is data in every cell in columns A:L, but I'm only going to do the first two columns.
    A1:L1 have headers on them, so they can't change. Data in () is to show what cell the data is in.

    On Sheet1 (where data gets pasted), this is how it looks starting in cell A2, etc.

    (A2) Sally (B2) Order 1
    (A3) Sally (B3) Order 2
    (A4) Sally (B4) Order 3
    (A5) Bill (B5) Order 1
    (A6) Mike (B6) Order 1
    (A7) Mike (B7) Order 2
    (A8) Dave(B8) Order 1

    On the Sheet2
    There is a named range called "SF", which does not include Sally's and Dave's name. So, the macro would delete their rows, and move the others towards the top so it would look like:
    (A1)Bill (B1) Order 1
    (A2)Mike (B2) Order 1
    (A3)Mike (B3) Order 2

    I hope that is enough information. Any help you guys could provide would be greatly appreciated.

    Thanks!
    Last edited by swolfe2; 05-17-2013 at 01:20 PM.

  2. #2
    Registered User
    Join Date
    04-02-2013
    Location
    Knoxville, TN
    MS-Off Ver
    Office 365
    Posts
    15

    Re: Macro to delete entire rows if cell values do not match list/named range.

    I figured it out!

    Please Login or Register  to view this content.

+ 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