View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lolly[_2_] Lolly[_2_] is offline
external usenet poster
 
Posts: 28
Default 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