Get instant live expert help on I need help with excel range sort

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I built a macro to auto sort but it is not working correctly. I need the table to be sorted when values change in column A, but I need the table to be sorted by column T. Here is the macro that I wrote: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Not Intersect(Target, Range("A7:A33")) Is Nothing Then Range("A7:T33").Sort Key1:=Range("T7"), _ Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End If End Sub
Solved by D. U. in 20 mins
I need to sort an excel spreadsheet with multiple columns and sort it alphabetically on the column F,
Solved by V. J. in 21 mins
How do I sort by month on an excel spread sheet? I am NOT good at excel but need to sort the year into 4 quarters. Help
Solved by B. Q. in 30 mins
How do I sort my excel data sheet by colour?
Solved by T. J. in 14 mins
Hello, I have a set of data that I need to sort by time range- but am having a lot of trouble doing it- is someone able to assist?
Solved by B. L. in 22 mins