I'm having trouble understanding what you are trying to do.The terms don't
quite make sense.Automatic sort? What is that?if you record a macro and define
your sort, the issue is that the selected range becomes "hard-coded" into the
macro.SortFields.Add Key:=Range("I2:I766")
means that if you add
Is there any specific reason you want to use VBA?
In the attached sheet, I used a helper column - please see if this serves
your purpose.
Regards,
On Mon, Aug 31, 2015 at 11:25 AM, Soumyendu Paul
wrote:
> Hi,
> Is there anyone to help?
>
> On Mon, Aug 31, 2015 at 5:18 AM, Soumyendu Paul
> w
Hi,
Is there anyone to help?
On Mon, Aug 31, 2015 at 5:18 AM, Soumyendu Paul
wrote:
> Hi,
> In attached file there is a date column containing all dates of
> September month. I want to sort data like 1Sep, 2Sep, 3rd Sep irrespective
> of year using VBA. Please help me.
> Regards,
> Soumyendu
you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
> From: amar takale
> To: excel-macros@googlegroups.com
> Sent: Monday, October 13, 2014 8:48 AM
>
> Subject: Re: $$Excel-Macros$$ Sort VBA require
her"
>>> >> > (your example seemed to suggest that "Other" was in the BSE column,
>>> >> > but
>>> >> > you
>>> >> > data has it in the Nifty50 column)
>>> >> >
>>> >> > Once I had thes
r example seemed to suggest that "Other" was in the BSE column,
>> >> > but
>> >> > you
>> >> > data has it in the Nifty50 column)
>> >> >
>> >> > Once I had these recorded macros, I cleaned them up a bit (by addin
the Nifty50 column)
> >> >
> >> > Once I had these recorded macros, I cleaned them up a bit (by adding
> an
> >> > IF()
> >> > test to the showall macro, and others)
> >> >
> >> > then assigned the macros to the buttons.
&g
gt; > IF()
>> > test to the showall macro, and others)
>> >
>> > then assigned the macros to the buttons.
>> >
>> > It SEEMS to do what you're asking.
>> >
>> >
>> > Paul
>> > ---
> In all the places you can,
> > At all the times you can,
> > To all the people you can,
> > As long as ever you can.” - John Wesley
> > -
> >
> > From: amar takale
> > To: excel-macros@googlegroups.com
> > Sent
ou can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> ---------
>
> From: amar takale
> To: excel-macros@googlegroups.com
> Sent: Tuesday, October 7, 2014 9:57 AM
> Subject: Re: $$Excel-Macros$$ Sort VBA required
>
can,
As long as ever you can.” - John Wesley
-
>
> From: amar takale
>To: excel-macros@googlegroups.com
>Sent: Tuesday, October 7, 2014 9:57 AM
>Subject: Re: $$Excel-Macros$$ Sort VBA required
>
>
>Dear sir
>
>Pls
Dear sir
Also I required if i hit show all button then show all stocks
Regards
Amar
On Tue, Oct 7, 2014 at 7:27 PM, amar takale wrote:
> Dear sir
>
> Pls find attached sheet where I show how to look output.Actually I
> want after hit specific tab (like nifty,bse & other) will show that
> under
where you want output? Same sheet or diff sheet?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 7, 2014 at 7:27 PM, amar takale wrote:
> Dear sir
>
> Pls find attached sheet where I show how to look output.Actually I
> want after hit specific tab (like ni
Dear sir
Pls find attached sheet where I show how to look output.Actually I
want after hit specific tab (like nifty,bse & other) will show that
under category Stocks thats it.
I hope clarify my issue
Regards
amar
On Mon, Oct 6, 2014 at 7:14 PM, Paul Schreiner wrote:
> I'm not sure about your r
I'm not sure about your requirement.
You SAY you want to sort, but what you're describing is a filter.
Sorting implies a change in sequence,
Filter implies hiding rows that do not meet specific criteria.
And... why would it matter if a stock appears in both categories?
Even if you were sorti
Dear Bé Trần Văn
Thanks very much for this & noe it open in excel 2003 version also work it.
But small issue that VBA code would be copy & paste in sheet module
for each column & change column numbers in code & attached button that
code every time.IF there are more than 30 cloumn then 30 times VB
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
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
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
Share your workbook in which you are applying this method and let me check
why it is not working.
On Tuesday, 1 July 2014 11:05:27 UTC+5:30, amar takale wrote:
>
> Dear lalitji
> code not working
>
> On Tue, Jul 1, 2014 at 8:00 AM, Lalit Mohan Pandey
> > wrote:
> > I have checked it and it is
You change the Sort row here
Rows("7:2000")
7: Sort line that begins
2000: Sort to the last line, if greater than 2000 sort pregnancy weight on
you instead of here
example:
Rows("5:32000")
You change the Sort column in this line
Range("D7")
Sort column H
Range("H7")
Sort column K
Range("H7")
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
Dear Bé Trần Văn
Code is good but required data sort each column but code sort data on
basis of D7 cell only ,if i want sort it another column then need to
change cell numbers each time then work done in some time.
Can we give as header row No 6 as ascending & descending then we can
sort data with
Dear lalitji
code not working
On Tue, Jul 1, 2014 at 8:00 AM, Lalit Mohan Pandey
wrote:
> I have checked it and it is working fine but give a try to this code:
>
> Sub SECEPSDES()
>
> With ThisWorkbook.Worksheets("Sector Valn")
> .Sort.SortFields.Clear
> .Range("A6:U21").Sort
I have checked it and it is working fine but give a try to this code:
*Sub SECEPSDES()*
*With ThisWorkbook.Worksheets("Sector Valn")*
*.Sort.SortFields.Clear*
*.Range("A6:U21").Sort Key1:=.Range("E7:E21"),
Order1:=xlDescending, Header:=xlYes*
*End With*
*End Sub*
To use the code for another sheet, you add 2 lines of code on the start and
end Module.
With ActiveWorkbook.Worksheets("Sheet1")
End With
Sheet1 is the name you need to reference sheet.
For example:
Sub SortAscendingD_Sheet1()
With ActiveWorkbook.Worksheets("Sheet1")
Rows("7:2000").Select
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
Dear latit mohan,
when i use above code which you provide show error "object does not
support this property or method" in excel.Pls give me proper guidance
Regards
Amar
On Mon, Jun 30, 2014 at 10:17 AM, amar takale wrote:
> Dear Bé Trần Văn
>
> Thanks very much sir. but i ask you small is
Dear Bé Trần Văn
Thanks very much sir. but i ask you small issue can we use one
code to all filed like lalit mohanji code.I use this code but erroe
show "object does not support this property or method"
Thanks once again
Regards
Amar
On Sat, Jun 28, 2014 at 3:34 PM, Bé Trần Văn wrote
Yes it will work in excel 2003 and above
On Friday, 27 June 2014 15:31:54 UTC+5:30, amar takale wrote:
>
> Dear Lalit Mohan
>
> Then it code not work in excel 2003?
>
> On Fri, Jun 27, 2014 at 3:24 PM, Lalit Mohan Pandey
> > wrote:
> > change your code as i have changed it:
> >
> > Sub SECEP
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
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
Dear Lalit Mohan
Then it code not work in excel 2003?
On Fri, Jun 27, 2014 at 3:24 PM, Lalit Mohan Pandey
wrote:
> change your code as i have changed it:
>
> Sub SECEPSDES()
>
> With ActiveWorkbook.Worksheets("Sector Valn")
> .Sort.SortFields.Clear
> .Range("A6:U21").Sort Key
change your code as i have changed it:
*Sub SECEPSDES()*
*With ActiveWorkbook.Worksheets("Sector Valn")*
*.Sort.SortFields.Clear*
*.Range("A6:U21").Sort Key1:=.Range("E7:E21"),
Order1:=xlDescending, Header:=xlYes*
*End With*
*End Sub*
*Sub SECEPSASC()*
*
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
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
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
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
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
Dear all
pls help me on this topic.
regards
amar
On Thu, Jun 26, 2014 at 1:21 PM, amar takale wrote:
> Dear Experts
>
> I have below attached excel which open in excel 2007 then sort VBA
> code work perfect but when it open in excel 2003 then show error.So
> pls guide me about it error & work a
Hi
PFA, result can be achieved using pivot table & dynamic reference.
Thanks
On Thu, Apr 17, 2014 at 2:25 PM, SG wrote:
> Hi vabz,
>
> Thanks for the reply but this is not solving my purpose.The data is not
> sorted on location & highest marks & i don't want to paste the visible data
> anywhe
Hi vabz,
Thanks for the reply but this is not solving my purpose.The data is not
sorted on location & highest marks & i don't want to paste the visible data
anywhere else. The sorting done only at that location i.e from colun A to D.
On Thursday, April 17, 2014 2:02:46 PM UTC+5:30, Vabz wrote:
PFA
Thx
On Thu, Apr 17, 2014 at 1:28 PM, SG wrote:
>
>
> Hi Experts,
>
> I need a solution to sort the data on basis of location & highest marks.
> For this, i have created a dynamic named range to call it by macro & then
> sort. My problem comes when the range also selects the blank formulas
Thanks Ashish for sharing this. Really very informative (Infact the website
itself contains huge information on VBA).
Hope to see something for sorting on Numbers...
Thanks,
Anish
On Fri, Jun 24, 2011 at 3:29 PM, OpenExcel.com <26may.1...@gmail.com> wrote:
> Are you a reporting analyst in IT fi
I need for the same records to stay together. rows 2 thru 8, rows 10
thru 16, rows 18 thru 24, rows 26 thru 32 and so on... Once a record
is completed, then delete, and then more everything up. Thanks so much
for your help!
On Dec 5, 8:26 pm, Ken Roedel wrote:
> Try this
>
> Sheet1.Columns(2)
Try this
Sheet1.Columns(2).Specialcells(xlBlanks).Delete
On Sun, Dec 5, 2010 at 6:36 PM, robert peloquin wrote:
> Sorry for the multiple post, trying to send an attachment, not sure how to
> go about this.
> I have a strange sort question. In column B there is information
> every
> 7 rows.
Thanks for your help. File is John Lathe.xls
On Dec 4, 9:00 pm, in.vaib...@gmail.com wrote:
> Pl send your excel sheet.
>
> Rgds
>
> Vaibhav J
> Sent on my BlackBerry® from Vodafone
>
>
>
> -Original Message-
> From: Dick
>
> Sender: excel-macros@googlegroups.com
> Date: Sat, 4 Dec 2010 1
Thanks for your help. File is John Lathe.xls
On Dec 4, 10:14 pm, ashish koul wrote:
> can you attach sample sheet..
>
>
>
>
>
> On Sun, Dec 5, 2010 at 8:11 AM, Dick wrote:
> > I have a strange sort question. In column B there is information
> > every
> > 7 rows. Then you skip 1 row (Blank) Then
This is my first time uploading files here, I hope I uploaded it to
the correct place. File name John Lathe.xls Thanks so much for your
help!
On Dec 5, 4:24 am, Sanjoy Nath wrote:
> pls send your excel sheet. I can prepare the tool for you.
>
>
>
>
>
> On Sun, Dec 5, 2010 at 10:30 AM, wrote:
> >
pls send your excel sheet. I can prepare the tool for you.
On Sun, Dec 5, 2010 at 10:30 AM, wrote:
> Pl send your excel sheet.
>
> Rgds
>
> Vaibhav J
> Sent on my BlackBerry® from Vodafone
>
> -Original Message-
> From: Dick
> Sender: excel-macros@googlegroups.com
> Date: Sat, 4 Dec 2
Pl send your excel sheet.
Rgds
Vaibhav J
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dick
Sender: excel-macros@googlegroups.com
Date: Sat, 4 Dec 2010 18:41:13
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Sort
I have a
can you attach sample sheet..
On Sun, Dec 5, 2010 at 8:11 AM, Dick wrote:
> I have a strange sort question. In column B there is information
> every
> 7 rows. Then you skip 1 row (Blank) Then there is the same
> information
> but with different dates in the next 7 rows and so on. Is it possible
Hi Skanda,
Using worksheet funtions, it would just be:
=MID(B6,7,19) copied down.
Programatically it would include a For/Next loop, but the otherwise look very
similar:
Sub SevenToTwentyfive()
For i = 6 To 1000
Cells(i, 3) = Mid(Cells(i, 2), 7, 19)
Next i
End Sub
This w
Hi,
What do you want to achieve by sorting?
Dave.
> Date: Thu, 13 May 2010 11:01:13 -0700
> Subject: $$Excel-Macros$$ Sort data in two nonidentical columns
> From: eller.n...@gmail.com
> To: excel-macros@googlegroups.com
>
> We have an Excel list with 3 columns. In the first column is the
> c
54 matches
Mail list logo
