L
Lolly
HI
everybody
In sheet1 I have a data like this
A B C D E F G H I
Sub Me M1 M2 M3 M4 M5 M6 M7
31 40 12 23 45 34 23 12 45
32 40 6 7 9 5 6 7 4
31 34 2 3 4 3 6 7 3
32 34 1 2 5 7 6 8 9
- 21 2 4 5 6 7 5 2
Sheet2 looks like this
A B C D E F G H ....
Sub Me M1 M2 M3 M4 M5 M6...
31 40
- 21
32 40
31 34
32 34
I need to match ColA and Col B in sheet1 and sheet2. When the the values of
ColA and ColB of sheet1
matches with the value of colA and ColB of sheet2 then I need to retrieve
the value of that row
from sheet1 and copy it in sheet2.
Any help would be highly appreciated
Thanx in advance
everybody
In sheet1 I have a data like this
A B C D E F G H I
Sub Me M1 M2 M3 M4 M5 M6 M7
31 40 12 23 45 34 23 12 45
32 40 6 7 9 5 6 7 4
31 34 2 3 4 3 6 7 3
32 34 1 2 5 7 6 8 9
- 21 2 4 5 6 7 5 2
Sheet2 looks like this
A B C D E F G H ....
Sub Me M1 M2 M3 M4 M5 M6...
31 40
- 21
32 40
31 34
32 34
I need to match ColA and Col B in sheet1 and sheet2. When the the values of
ColA and ColB of sheet1
matches with the value of colA and ColB of sheet2 then I need to retrieve
the value of that row
from sheet1 and copy it in sheet2.
Any help would be highly appreciated
Thanx in advance