pdx_2188
03-25-2011, 09:18 AM
I currently have a macro that I have created in which we have our clients input thier data into and it filters againts a list of our company's part numbers, and pulls out all matching part numbers and inputs them into another worksheet. Due to configure to order and built to order purchases that contain different part numbers we are unable to capture ALL of the data.
We do have part number lists from our competitors, so I was wondering what it would take to do the opposite of what I already have? I want to be able to take out our part numbers input our competitors, and basically say "If Part number doesn't match the list then move over to the other worksheet". Anyone have any experience with this? I'm attaching the template I use so you can see what i mean. The module will have all of the code I am currently using. Any tips or help would be greatly appreciated!
Thanks,
Jeff
We do have part number lists from our competitors, so I was wondering what it would take to do the opposite of what I already have? I want to be able to take out our part numbers input our competitors, and basically say "If Part number doesn't match the list then move over to the other worksheet". Anyone have any experience with this? I'm attaching the template I use so you can see what i mean. The module will have all of the code I am currently using. Any tips or help would be greatly appreciated!
Thanks,
Jeff