Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-07-02 Thread Vaibhav Joshi
Cheers!! On Wed, Jul 2, 2014 at 4:06 PM, amar takale wrote: > Dear Vabs Bro… > > Mind Freaking Vabs !!! Awesome!!! Great!!! > > Thank you so much for your code, for the effort and time dedicated to > work. I wish Ayush Sir will declared Vaibhav as 'Most Helpful Member' > in our excel forum

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-07-02 Thread amar takale
Dear Pramod,Thanks for your effort also. On Wed, Jul 2, 2014 at 4:06 PM, amar takale wrote: > Dear Vabs Bro… > > Mind Freaking Vabs !!! Awesome!!! Great!!! > > Thank you so much for your code, for the effort and time dedicated to > work. I wish Ayush Sir will declared Vaibhav as 'Most Helpful

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-07-02 Thread amar takale
Dear Vabs Bro… Mind Freaking Vabs !!! Awesome!!! Great!!! Thank you so much for your code, for the effort and time dedicated to work. I wish Ayush Sir will declared Vaibhav as 'Most Helpful Member' in our excel forum & give him certificate it will encourage to our group member to solve query mo

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-07-01 Thread amar takale
Dear Vabs I would appreciate very much if you can help me on this.I had try more effort on this problem but upset each time. Regards Amar On Mon, Jun 30, 2014 at 10:21 AM, amar takale wrote: > Dear Lalitji > > Can any suggestion on this topic? > > On Fri, Jun 27, 2014 at 4:16 PM, amar takale w

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-29 Thread amar takale
Dear Lalitji Can any suggestion on this topic? On Fri, Jun 27, 2014 at 4:16 PM, amar takale wrote: > Dear Lalit bro.. > > Thanks for this good one code but it is only for mkt cap column & i > required this filter for total Row no 7 means all field (If add other > criteria field in row 7). > So p

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread amar takale
Dear Lalit bro.. Thanks for this good one code but it is only for mkt cap column & i required this filter for total Row no 7 means all field (If add other criteria field in row 7). So pls as per my criteria solution,provide me VBA Code. One more small Question that i dont required filter arrow in

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread Lalit Mohan Pandey
Try this, I have created this for only MCap column: *Option Explicit* *Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)* *If Target.Address = "$D$7" Then* *Call FilterData* *Application.Goto Me.Cells(1, 1)* *End If* *End Sub* *Sub F

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread amar takale
Dear Lali Mohan Exactly i want data by sort based on multiple criteria range. Regards Amar On Fri, Jun 27, 2014 at 3:20 PM, amar takale wrote: > Dear Pramod > > First thanks for reply.If you see Raw sheet (Row No 7) cell D7,here > are I double click then mkt cap will sort as per criteria betwe

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread amar takale
Dear Pramod First thanks for reply.If you see Raw sheet (Row No 7) cell D7,here are I double click then mkt cap will sort as per criteria between 1000 to 5000 automatically which show output in output sheet,like this i will click each criteria Price,Roe... etc. & data sort as per criteria range in

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread Lalit Mohan Pandey
What do you mean by sort based on criteria? On Friday, 27 June 2014 15:03:04 UTC+5:30, pramodb35 wrote: > > Not Sure What you are saying. > > > Need more description. > > > > > > On Fri, Jun 27, 2014 at 11:28 AM, amar takale > wrote: > >> Dear All friends >> >> Can anyone suggestion pls? >> >> On

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-27 Thread Pramod Singh
Not Sure What you are saying. Need more description. On Fri, Jun 27, 2014 at 11:28 AM, amar takale wrote: > Dear All friends > > Can anyone suggestion pls? > > On Wed, Jun 25, 2014 at 12:17 PM, amar takale > wrote: > > Dear Expert team > > > > I Required code for sort data as per criteria

Re: $$Excel-Macros$$ Sort VBA Code Challenging difficult work

2014-06-26 Thread amar takale
Dear All friends Can anyone suggestion pls? On Wed, Jun 25, 2014 at 12:17 PM, amar takale wrote: > Dear Expert team > > I Required code for sort data as per criteria range in between > numbers.PFA with more detailed in sheet. > > Regards > Amar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E