Easily sort by frequency of occurrences in Excel
Kutools for Excel's Advanced Sort utility supports sorting data by text length, last name, absolute value, frequency, etc. in Excel quickly.
Full Feature Free Trial 60-day!
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save
70% of your time and solve
80% Excel problems for you.
300+ advanced features designed for
1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
This VBA macro will sort all data in a specific column automatically as soon as you enter new data or change value in the column in Excel.
1. Right click current sheet name in the Sheet Tab bar, and then click the View Code from the right-clicking menu.
2. In the opening Microsoft Visual Basic for Application dialog box, paste the following VBA macro code into the opening window.
VBA: Auto Sort Column in Excel
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Not Intersect(Target, Range("B:B")) Is Nothing Then
Range("B1").Sort Key1:=Range("B2"), _
Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Note: In the above vba code, B:B means it will auto sort Column B, B1 is the first cell in Column B, B2 is the second cell in Column B, and you can change them based on your needs.
3. Then go back to the worksheet, when you enter a new number in the Price column or modify any existing prices, the Price column will be automatically sorted in ascending order.
Note: when entering new number in the Price column, you must enter the number in the first blank cell below original numbers. If there are blank cells between new entered number and original numbers as well as blank cells between original numbers, this column won't be sorted automatically.