automatic sort

  1. A

    Auto Sorting By Date

    Greetings, I'm at the end of my rope trying to create an auto sorting excel spreadsheet. I am using Excel 2013. My active cells on the spreadsheet are A1-L126. My Headers are: A1-L1 A22-L22 A43-L43 A64-L64 A85-L85 A106-L106 I need cells A1-L21 to sort independently, A22-L42 to sort...
  2. K

    Automatic Sorting of Multiple Columns

    I'm trying to create a document that automatically sorts itself when values are changed or added. The first column I'm sorting is a numerical value, and I'm using the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Target, Range("C2:C99")) Is...
  3. B

    Macro to Automatically Sort Multiple Column Groups Separately As Data is Entered

    I have searched extensively, but have not found a solution to fit my specific need so it is time to ask for help. I have a worksheet that contains multiple task lists, each having two columns, a "Priority" field and a "Description" field. The data should be sorted by Priority first and by...
  4. M

    Automatic Sorting of Sheet Based on One Column Value

    As the title suggests, I'm trying to sort a sheet of data based on a single column, and then have further entries automatically sort. The data has columns A-L, I would like it sorted based on column K, discounting the headers which are in row 1. The values in column K are 1,2 or 3 and there are...
  5. R

    Automatic sort in another sheet

    Hi all, My 2003 workbook has two sheets - 'Data' and 'Front' The user enters data in five columns - A-E in the 'data' sheet. The entered data is a dynamic named range called 'members' which grows/shrinks according as data is entered/deleted. A cell in the 'Front' sheet is validated to show...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top