MACO that does a lookup on values entered in one workbook, returns results from another WB

[drobinson782001]

I have a workbook named COUNTRIES where users enter country names in column L2 and below
(the header name is CountryCodes and located in L1 )
ExAMPLE OF ENTRIES COUND BE
United States
Afghanistan
Aland Islands
Albania etc
The MACRO should then do a lookup on another workbook named COUNTRYCODES and then map the codes example


United States = US
Afghanistan = AF
Aland Islands= AF
Albania = AL etc

so the out put sheet should only have US, AF,AF,AL etc.

This is How it looks on the COUNTRYCODES workbook


COLUMN A COLUMN B


Long_Country Country_Code
United States US
Afghanistan AF
Aland Islands AF
Albania AL
Algeria DZ
American Samoa AS
Andorra AD
Angola AO
Anguilla AI
Antarctica AQ



ALL THE WAY TO ROW 245 with other countries and codes

[FDibbins]

Why do you feel you need VBA for this? A regular vlookup*() will give you what you want, even if the other W/B is closed. Create it in the exact same way as if the other WB was another worksheet instead