Results 1 to 19 of 19

need formula for finding and removing orders

Threaded View

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    Simi Valley, California
    MS-Off Ver
    Excel 2007
    Posts
    15

    need formula for finding and removing orders

    Can any one help with what Im trying to do. I have a list of all of our Open line Items. I need a formula or VBA that can locate all orders that have Part #'s 2000 & 2005 and remove the entire order including the other part #'s on the same order. See example below.
    Noted the lines that need to be removed because there order contains a 2000 or 2005.

    A B C
    1 Order # Part # Qty
    2 137047 1951 2
    3 137050 1952 4
    4 137086 2000 1 Remove
    5 137086 1951 1 Remove
    6 137095 2000 2 Remove
    7 137096 2000 4 Remove
    8 137096 1955 1 Remove
    9 137100 1957 1
    Last edited by Kenekio; 11-05-2010 at 07:35 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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