Macro To Copy Data [Solved/Closed]

Report
Posts
1
Registration date
Sunday September 16, 2012
Status
Member
Last seen
September 16, 2012
-
 ek2teen -
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 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
use vlookup
Thanks for ur reply Rizvisa1 but still no success :(
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
what do you mean by no success. did you try to use vlookup, why it is not sucess
Thankx Rizvisa1 its d0ne :)