Urgent help(Find, match and copy)
 

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
--
Kittie