AUtomatically sorting data as rows are updated

[MGrot]

Hello! I am an excel novice, but I want to learn, and could use some help!

I have an excel spreadsheet, which tracks documents that go through several phases. At each phase, I insert the date in a new column. The dates are in columns C-K. As I enter in a new row for a document, it is assigned a number and name into columns A and B, then as I push the document along, I enter a date in columns C-K as they occur. A total row goes from A-Q ans there are a couple more columns on the end with supplemental information.

I currently have it conditionally formatted to change color as each date is entered, and I have applied a filter to where, when applied, it puts the newest documents on top and oldest on bottom based off of the cell color. I would like to make this filter either:

OPTION 1: Change automatically as data is entered. This creates an issue as after you enter the first column, it shifts it around so you have to locate it to continue to the second column and so on. If anyone knows of a fix (like where a row won't move until you complete work in that row) that would be ideal.

OPTION 2: Update and apply the filter every time the document os saved, or opened.

OPTION 3: Does anyone with more expertise have a better way to apply the filter?

Any help is greatly appreciated!

 

[MGrot]

I tried the coding below but I can't get it to work. I recorded myself using the autosort that I had created, then tried to apply it to the spreadsheet everytime it is close. Unfortunately it isnt working. Any help?Sub Auto_Close()
'
' sort Macro
' autosort rows based on stage
'


'
ActiveSheet.ListObjects("T_MOR").AutoFilter.ApplyFilter
With ActiveWorkbook.Worksheets("DATA").ListObjects("T_MOR").sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub

 

[MGrot]

Sub Auto_Close()
'
' sort Macro
' autosort rows based on stage
'


'
ActiveSheet.ListObjects("T_MOR").AutoFilter.ApplyFilter
With ActiveWorkbook.Worksheets("DATA").ListObjects("T_MOR").sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ing-help-sorting-data-please.html#post5084835

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.
As you have had a response on the other thread, I'll close this one