Thread: Match column values in 2 sheets and pull data from main sheet

Sheet 1 Student Information Data

PG1.gif

Sheet 2

PG2.gif

Expected Result Sheet2

PG3.gif


Red color values need to pull from the sheet1 using macro.....

please let me know anything else... on the above requirement....

i need VBA macro for the above...can you plz give the elaborated answer & coding for the above....

thanks in advance
gnanavel