I have an excel sheet with roll numbers in columns A2 to A94 in sheet1 which is random. At the same time in sheet 2 i have 93 roll numbers in column G2 to G94 and their corresponding names in columns H2 to H94.
I need an excel vba code which copies the corresponding names in columns B2 to B94 in sheet1.