Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-17 Thread Wassi Agnihotri
Hello Vabs, Thanks again.Really helpful group with helping hand. Love you all because you guys help without shouting. On Sat, Sep 15, 2012 at 5:15 PM, Vabz wrote: > Hi > > Thanks.. for acknowledgement!! :) > > Happy to Help Excel Lovers.. > > Cheerz.. > > Rgds//Vabs > > > On Saturday, Septem

Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-16 Thread Vabz
Hi Thanks.. for acknowledgement!! :) Happy to Help Excel Lovers.. Cheerz.. Rgds//Vabs On Saturday, September 15, 2012 5:04:02 PM UTC+5:30, Wassi wrote: > Hello Vabs. > > Hats off bro. Both of your solution are working for me. > Thank you. > > Cheers > > On Sat, Sep 15, 2012 at 4:52 PM

Re: $$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-15 Thread Wassi Agnihotri
Hello Vabs. Hats off bro. Both of your solution are working for me. Thank you. Cheers On Sat, Sep 15, 2012 at 4:52 PM, Vabz wrote: > HI > > You can also use this formual.. > > =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number > > After that copy & paste sepcial all data to its v

$$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-15 Thread Vabz
HI You can also use this formual.. =OFFSET(A2,1,1,) for Company & =OFFSET(A2,1,2,) for Phone number After that copy & paste sepcial all data to its value, then filter all data. After that filer on coloumn A & selct only Blank & delete visible cell so that you will get only desired data and

$$Excel-Macros$$ Re: Please Help to Find out the solution

2012-09-15 Thread Vabz
Hi See Sheet with formula.. Let me know if itz fyne. Cheerz.. Rgds//Vabz On Saturday, September 15, 2012 2:54:36 PM UTC+5:30, Wassi wrote: > Hello Friends, > I am new using vba excel. Please help me to find > that how we can select after Vlookup. > > In attached workbook i m trying to fi