Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-18 Thread Prince
ooglegroups.com ] *On Behalf Of *Deepak Rawat > *Sent:* 18 February 2013 12:43 > *To:* excel-macros > *Subject:* Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work) > > > > Hi Rajan, > > > > great trick > > > > could u explain how did u put t

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-18 Thread Divaker Pandey
egards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat >> *Sent:* 18 February 2013 12:43 >> *To:* excel-macr

RE: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-17 Thread Rajan_Verma
[IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: 18 February 2013 12:43 To: excel-macros Subject: Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work) Hi Rajan, great trick could u explain how did u put the image.

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-17 Thread Kanwaljit Singh
Dear Amar, What Rajan did was indeed great ! It would be highly efficient and versatile if you can arrange yours data to be in proper shape Like Giving Sr No for each of the start up item like Lupin, Glenmark etc and avoid using blank rows within. Then you can extend the solution to fetch any rang

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-08 Thread amar takale
Dear Rajan, If there are more than 4 table range data then there no problem about excel size increase? And also can we expand range whatever we need,there is no issue? Regards Amar On Sat, Feb 9, 2013 at 10:42 AM, amar takale wrote: > Dear Rajan, > This is Excellent, mind blowing trick,I like it

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-08 Thread amar takale
Dear Rajan, This is Excellent, mind blowing trick,I like it very..much & I used it in my future Excel work. Thanks alot ** Regards Amar On Fri, Feb 8, 2013 at 9:29 PM, Shekhar wrote: > A good trick Rajan, Thanks for your post. > > > Thanks and regards, > Shekhar > > -- > Are you =E

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-08 Thread Shekhar
A good trick Rajan, Thanks for your post. Thanks and regards, Shekhar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thr

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

2013-02-08 Thread Naresh Kumar Kolluru
Looks great and interesting. Interested to know if you have a used a macro or some formula. If possible, Pl. explain so that we can learn. On Fri, Feb 8, 2013 at 8:42 PM, rajan verma wrote: > see if it helps > > > On Fri, Feb 8, 2013 at 5:19 AM, amar takale wrote: > >> Dear All, >> Pls suggest a