Re: $$Excel-Macros$$ VBA Code to extract data in row

2011-08-05 Thread mohd saber
hi Raghavendra, please find the attached file with the solution. On Fri, Aug 5, 2011 at 4:57 PM, Raghavendra wrote: > Hi , > > ** ** > > Can anyone suggest me VBA code to perform task as mentioned in the attached > file. > > ** ** > > Regards, > > Raghavendra > > -- > >

RE: $$Excel-Macros$$ VBA Code to extract data in row

2011-08-05 Thread Rajan_Verma
Try this Sub Extract() Dim rng As Range Dim cell As Range Dim iCounter As Integer Dim Rng2 As Range Dim cell2 As Range Range("A:A").Copy Range("E1") Range("E:E").Select Selection.RemoveDuplicates 1 Set rn