asked on
Sort Data
I need Experts advice. Can we sort the data at Data sheet (attached the script) at the same time maintaining the row group (+)?
Sub SortingAtoR()
Intersect(Range("A1").CurrentRegion, Range("A:R")).Sort _
Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("B2"), Order2:=xlAscending, Header:=xlYes, _
OrderCustom:=1, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortTextAsNumbers
End Sub
Microsoft ExcelMicrosoft Office
Last Comment
Billa7
You can record a macro removing the grouping, sort, then reapply the grouping.
It really depends on how you are sorting and what your grouping logic is.
It appears to me from your last grouping workbook I worked on with you, that doing a date then title sort which appears to be what you're doing, you would invalidate the groups.
I tested with test data....
It appears that the sort you have doesn't even sort within groups when I change the data to test, but when I remove the groups, the sort works, correctly, but then the grouping is gone.
So, if you provide the grouping logic, we can remove the group, run the sort, then add the group back.
What is the grouping logic for your rows?
Dave
It appears to me from your last grouping workbook I worked on with you, that doing a date then title sort which appears to be what you're doing, you would invalidate the groups.
I tested with test data....
It appears that the sort you have doesn't even sort within groups when I change the data to test, but when I remove the groups, the sort works, correctly, but then the grouping is gone.
So, if you provide the grouping logic, we can remove the group, run the sort, then add the group back.
What is the grouping logic for your rows?
Dave
ASKER
Hi Dave,
I groping the date base on week (Monday to Sunday); I do realized by data without day reference. Are we still able to group the date without day reference? if yes, that will be great.
I groping the date base on week (Monday to Sunday); I do realized by data without day reference. Are we still able to group the date without day reference? if yes, that will be great.
We can group on column A. Is your definition of week from Sun to Saturday?
ASKER
Hi Dave,
Yes, we can do that way.
Yes, we can do that way.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Billa - are we done with this, ready for close out?
Dave
Dave
ASKER
Thanks Dave.
Sorry for the delay.
Sorry for the delay.