Get instant live expert help on I need help with excel auto sort macro
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
macro enabled workbook that will make the dashboard sheet auto refresh itself
Solved by I. C. in 12 mins
Have a spreadsheet and need assistance with doing a random sort of names that only sort once to tie to a macro.
Solved by K. B. in 22 mins
Record a macro named Sort. Ensure the macro sorts the Inventory list in ascending order based on the dates listed in column F.
Solved by V. U. in 17 mins
I need a macro that will auto populate the chart with dates
Solved by C. U. in 11 mins
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