I have a dynamic list of items on one sheet and I need to compare
each one with a fixed master list (or array). Then, if I have a
match, I need to specify a particular action.
An example would be:
Dynamic list on sheet1 (changes every month, generated by database):
Peaches
Pears
Peaches
Apples
Peaches
Oranges
Fixed master list (can be on another worksheet or an array):
Apples
Peaches
Pears
Oranges
I would take the first item, Peaches, and compare it to the master
list until I have a match, then specify an action (like moving it to
another sheet).
Then take the second item, Pears, and do the same.
However, I'm looking for a quicker and better way than just for-
next'ing through each item.
I've thought about using a Do loop with a nested counter, or using
the Find/Findnext commands, but can't seem to find an easy, brief
way to do this.
Any help?