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
Hi,
automatic Sort with the macro recorder or normal sort with three levels do
not give me the expected results.
Sorting descending, between the same values in one column the other column
is not sorting any more, until the value changed again.
is there a routine already in VBA ?
PS there is no
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
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
--
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)
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
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: Monday, October 6, 2014 9:25 AM
>> Subject: $$
> In all the ways you can,
> > 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: exc
gt; 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: Monday, October 6, 2014 9:25 AM
> Subject: $$Excel-Macros$$ Sort VBA requi
e you can,
As long as ever you can.” - John Wesley
-
>
> From: amar takale
>To: excel-macros@googlegroups.com
>Sent: Monday, October 6, 2014 9:25 AM
>Subject: $$Excel-Macros$$ Sort VBA required
>
>
>Dear all experts
>
>I required VBA code for sortin
Dear all experts
I required VBA code for sorting.pls see with detailed in excel.
Regards
Amar
--
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) U
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
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 Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.face
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
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 in
sheet which shouldn't be selected. Only visible data should s
Heed help is sorting hidden rows. Is there a vb macro code that someone can
help me with to sort reguardless if the rows are hidden or not.Thanks in
Advance!!!
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for vi
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
Are you a reporting analyst in IT firm, network engineer, networking analyst
or any one who works on network data? If yes, then you ever tried to sort
TCP/IP Addresses, I'm sure something like red list in this figure, would
have happened and you must have desired the green list. This is the issu
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.
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. 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 p
ooglegroups.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 strange sort question. In column B there is information
> every
> 7 rows. Then you skip 1 row (Blank) Then th
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
13
> > To: MS EXCEL AND VBA MACROS
> > Reply-To: excel-macros@googlegroups.com
> > Subject: $$Excel-Macros$$ Sort
>
> > 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
>
egroups.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 strange sort question. In column B there is information
> every
> 7 rows. Then you skip 1 row (Blank) Then there i
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
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
once there is information in All seven rows to delete that
information
and move everyth
I am trying to duplicate the sort feature used in this tutorial:
http://www.contextures.com/xlSort02.html
The description of the first part of the code suggests that the code
creates the invisible rectangles, but I couldn't get it to do this. (I
had the create the rectangles manually, ahead of ti
h 1000 formulas.
Regards - Dave.
Date: Sun, 1 Aug 2010 11:49:27 -0400
Subject: $$Excel-Macros$$ Sort and then extract digits from 7 to 25
From: skanda.pokkun...@gmail.com
To: excel-macros@googlegroups.com
Hi All,
The report that I generate is sorted on column "S" and then it is hidden
Hi All,
The report that I generate is sorted on column "S" and then it is hidden
using VBA code.After the sorting is done I want to display only characters
from 7 to 25 from row b6 to B1000.
Eg. PM 00 New York,NY. We need to diaplay only New York,NY.How to
do this programatically?
Tha
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 f
We have an Excel list with 3 columns. In the first column is the
client name, second column is their email address (the full newsletter
list) and the third column is a list of nonprofits on our email list.
Nick 1
Jerry 2 2
Tom 3 3
Bill4
Does anyone have a
stcity price
oha 20
oha30
oh a sum 50
mib40
mib 80
mi b sum 120
I HAVE THE ABOVE DATA WITH GROUPS SEPERATED BY SUBTOTALS. NOW I WANT
TO SORT THE GROUPS BY THE SUBTOTAL VALUE IN DESC ORDER. for example i
i want to sort the grouped dat by sorted value in desc order. for
example the second group has to come above the first group since 120
is greater than 50. So the entire group mi b i.e the two rows and the
subtotaled row should come first and then the first group
stcity price
oh
Help ! I need some vb to organise example list below what I need
is for category to have type after it, the earliest date only &
number
on the day & the total
EXAMPLE
Type : Cancel
Category : Cards
Receipt Date : 2009-04-20 1
Receipt Date : 2009-04-23 2
Rec
Help ! I need some vb to organise example list below what I need
is for category to have type after it, the earliest date only &
number
on the day & the total
EXAMPLE
Type : Cancel
Category : Cards
Receipt Date : 2009-04-20 1
Receipt Date : 2009-04-23 2
Rec
Help ! I need some vb to organise example list below what I need
is for category to have type after it, the earliest date only & number
on the day & the total
EXAMPLE
Type : Cancel
Category : Cards
Receipt Date : 2009-04-20 1
Receipt Date : 2009-04-23 2
R
Hello Everyone,
Could anyone write an excel macro to do the below tasks (in Excel
2003) ?
I have a "complete" set of names in a sheet named PV. However, the set
of names are not together and therefore I need to select the range.
Here the data need not be in alphabetical order.
I have another sh
72 matches
Mail list logo