This content has been marked as final. Show 2 replies
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.