automatic sort

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

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

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

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

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