Macro To Copy Data

Solved/Closed
ek2teen Posts 1 Registration date Sunday September 16, 2012 Status Member Last seen September 16, 2012 - Sep 16, 2012 at 03:20 AM
 ek2teen - Sep 23, 2012 at 11:28 AM
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

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 16, 2012 at 11:46 AM
use vlookup
0
Thanks for ur reply Rizvisa1 but still no success :(
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 21, 2012 at 05:23 AM
what do you mean by no success. did you try to use vlookup, why it is not sucess
0
Thankx Rizvisa1 its d0ne :)
0