Basically I am trying to match using a For loop
the codes in Sheet2 to the names in Sheet1.
So each code must be given a name accordingly in sheet2.
Now I know this could be done easily using Vlookups and thats what
I am using for my current spreasheet which is reall huge and its
taking a long time to run the macro that does a vlookup for each row in sheet2.
So I need to find out how to do it using a for loop
Please include a button to execute the macro.