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