I have a long list of items in a column with the field heading
"products" in an excel worksheet. Some of these items are "standard"
whiile some are not. The full reference set of standard items are in a
separate worksheet called "Standards" where there is a column with the
field heading "products".

I'd like for excel to go to the first cell under the heading "products"
where I have the list of items and to check whether this item is one of
the standards by looking in the reference worksheet "Standards" under
the heading "products".

If it is one of the "standards", then go to procedure 1.
If it is not one of the standards", then list this in a separate newly
created worksheet. So that there is a list of all non-standard items in
the new worksheet.

Thanks.

Matthew Kramer




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!