Replace values if criteria meet in to another file

I have two files one name is first and another name is second , i want that if name which is in first file in C column match with name in second file which is in H column if both name matched then copy value of B column from first file and paste that value in second file in G column , please see before after sheet so please give me VBA code for above process

Please Login or Register  to view this content.

So what does that tell you?

ok now my problem is solved , thanks for your help, you did not tell me that both files should be opened VBA code place in second file