Hello:
Please refer to attached file.
I need VB Code to filter data in ascending order by first sorting column D, then column E and then then Column G
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I need VB Code to filter data in ascending order by first sorting column D, then column E and then then Column G
Let me know if you have any questions.
Thanks.
Riz
Hi, test my code.Sub Sort_DEG() Application.ScreenUpdating = False With Sheets("Sheet1") .Sort.SortFields.Clear .Range("D2:I" & .UsedRange.Rows.Count).Sort _ Key1:=Cells(2, "D"), Order1:=xlAscending, _ Key2:=Cells(2, "E"), Order2:=xlAscending, _ Key3:=Cells(2, "G"), Order3:=xlAscending, _ Header:=xlYes, MatchCase:=False, _ Orientation:=xlSortColumns .Sort.SortFields.Clear End With End Sub
Best Regards,
Maras.
Hello maras
Seems to work, will test further and let you know if any questions
Thanks a lot
R
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks