Macro To Copy Data

Hello,

I have two excel sheet with three column on each sheet
Sheet 1
Sr.NO Code Name
1 1256
2 1256
3 1258
4 1258
5 1259
6 1259
7 1259
8 1234
9 1234
10 1111
Sheet 2

Sr.NO Code Name
1 1256 Ahmed s/o Nazir
2 1258 Nasir s/o Kabir
3 1259 Javeed s/o Mujtaba
4 1260 Ikhlaq s/o Nisar
5 1234 Qamar s/o Shakeel
6 1111 Shahzad s/o Jazy
7 1112 Waqas s/o Tahir
8 1113 Moon s/o Aslam
9 1114 Ammar s/o Aziz
10 1115 Jabbar s/o Mirza

I want to copy Names from sheet two if codes are equal. plz help THank You