2 Replies Latest reply: Aug 11, 2011 2:48 PM by Justin Kelly RSS

    Exclude Multiple Records in Script

    Justin Kelly

      I have a problem that doesn't seem too complicated but I just can't figure it out. I have two Excel files, one with all of my product data and one that is just a list of products that I need to exclude from the data. Example:



      Product#, Name, Inventory

      1001, A, 500

      1002, B, 600

      1003, C, 200

      1004, D, 700

      1005, E, 900

      1006, F, 100

      1007, G, 200









      From what I've searched for on the boards, WHERE NOT looks like it is the solution for excluding a few items in the script, but I have a lot more than just a few exclusions and they may change from week to week.


      Any help would be greatly appreciated.




      -- Justin