Dear All, I have a problem in Excel. I need a macro that compare two columns in sheet1 and sheet2 and for matching items from sheet2, copy selected cells from respective rows and paste them in corresponding matching rows in sheet1. My data is as follows, in Sheet1
Col A , Col B, Col C, Col D, .........................
Date , Name, ID# , Age
2/1/11, Ali, A-2145, 17
3/2/10, Umar, B-2204, 18
1/1/9, Raza, A-1191, 43
......, ......., .........,.....
......,........,..........,.....
whereas in Sheet2,
Col A , Col B, Col C, Col D, .........................
ID# , Total Marks, Marks Obtained, Grade, Status,
L-1412, 500, 417, A , Pass
B-2204, 800, 622, B , Pass
C-1214 100, 18, F , Fail
........., ....., ....., .. , .....
........., ....., ....., .. , .....
........., ....., ....., .. , .....
I want a loop that matches entries in Col C of Sheet1 against the entries in Col A of sheet2 and if it matches, it copies the cells of Marks obtained and grade in respective ROWS and paste them in sheet1 after Colum D, against matched entries.
I would be grateful for this help. I am a layman to Macros.
Bookmarks