You seem to think that everything should be done with macros.
Excel is smarter than that.

I think this particular problem could be solved using the Vlookup function.
Your description of the problem makes sense, but Excel doesn't need a macro
to do that.
The Vlookup function can scan through a list without a macro.
That's what it's there for.

But even better than that, use the External Data wizard and MSQuery, bundled
with Excel, to join the 3 tables.
And extract your results with a pivot table.
But that's a bit more advanced.
Start with the easy stuff.

Gloria.






"fifi" a écrit dans le message de news:
...
I have two worksheetsa with information that is the same but the text
is same
foe example
worksheet 1 has a column of countries e.g United Kingdom
Worksheet 2 has a column of countries abbreviations e.g UK (aswell as
other info e.g population, size etc)
and i have worksheet 3 which has two rows e.g United Kingdom and
UK...im using this as a translation table to find UK from United
Kingdom in 1st worksheet
can anyone help me...i wana create a macro to loop through the
countries column in worksheet 1, search through the translation table
(worksheet3) to get the abbreviation and then search worksheet 2 for
this to copy some info from that row back into worksheet1....if any of
this makes sense!!