Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a spreadsheet to auto sort data entry
Have a spreadsheet that is created each month to track the reappointment
applications for that month, there are 16 various stages the application could be in and the number 1-16 is entered into column A. I want to be able to set up the spreadsheet to auto sort based on the entry in Column A upon update of the value. Each case starts at 1, depending on its progress through the review process would dictate the number value beyond 1, each time I update the record to show progress I want my spreadsheet to automatically resort the rows of data based on the updated value. Is this possible. -- Judy Rose Cohen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting a spreadsheet to auto sort data entry
Say your data is in columns A & B. Whenever you update a record in column A
(manually), we want column A & B to re-sort automatically. Assume there is a header row in row #1. Enter the following event code in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("A:A"), Target) Is Nothing Then Exit Sub n = Cells(Rows.Count, "A").End(xlUp).Row Application.EnableEvents = False Range("A1:B" & n).Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Application.EnableEvents = True End Sub Naturally, enter data in column B before column A. -- Gary''s Student - gsnu200787 "Judy Rose" wrote: Have a spreadsheet that is created each month to track the reappointment applications for that month, there are 16 various stages the application could be in and the number 1-16 is entered into column A. I want to be able to set up the spreadsheet to auto sort based on the entry in Column A upon update of the value. Each case starts at 1, depending on its progress through the review process would dictate the number value beyond 1, each time I update the record to show progress I want my spreadsheet to automatically resort the rows of data based on the updated value. Is this possible. -- Judy Rose Cohen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Lock sort on a data entry sheet. | Excel Worksheet Functions | |||
setting worksheet so it ends at last data entry in column | New Users to Excel | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) | |||
More help with setting print area to last entry in columns A thru AA and last entry in row 7 | Excel Programming |