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...

Some videos you may like

This Week's Hot Topics