I'm still fairly new to programming excel but I understand basic programming
concepts and logic. I have four arrays called stgOffers, stgOffdups,
stgClients1, stgClients2. Here's what I'm looking to do:

Layout of data -- in column b are clients and they're housed in the array
stgClients2 In column c are entries that may be duplicates. these entries
are housed in the array stgOffdups. In a separate worksheet I have a column
with entries that are stored in stgOffers. In yet another worksheet I have a
column with entries that are stored in stgClients1.

What to do -- I need a loop that will take the first entry of stgOffers
(call it A) and then compare each entry of stgOffdups to A. If any entry in
stgOffdups = A then I need to compare the first entry of stgClients1 (call it
B) to every entry in stgClients2. Now, whenever an entry of stgClients2 = B,
I need to perform a specific action. I can code the specific action (I
think) but I can't seen to get this massive If For Next Then off the ground.

If anyone can give me a hand I would be most appreciative. Please send me
an email at if you would like to see the code that
I have right now.

Thanks again!
Nate