Find and Match in one worksheet and get data (Very Urgent)
I have two worksheet named sheet1 ans sheet2
My sourcedata in sheet one in two columns is as follows
V1 V2
30 100
31 100
- 206
- 323
30 202
31 203
If these two value matches in both sheets i.e sheet1 and sheet2 then I have
to copy the data from sheet2 to sheet1 in a row corresponding to that value
Any help will be greatly appreciated
Thanx in advance
Lolly
--
Kittie
|