Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Need to compare individual list items with fixed master list

  Asked By: Ibthaj    Date: Nov 22    Category: MS Office    Views: 1170
  

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?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 




Tagged: