excel vba training - Sort & Filter by Date

You can acheive this by extending your filter area further down the page. This means that when you add new lines, they will be included.
So, select the area with your data, including headings, and an additional 50 lines.
Then autofilter.


The other aspect would be for you to setup a VIEW.
Click View, then Custom views.
This allows you to set specific autofilter settings, and then save that view, to that you can get back to the setting you want very quickly.
Once you have setup the custom views, you could also add a toolbar using:
Right-click Toolbars, Customise, and looking under the Toolbars tab and dragging the CUSTOM VIEWS label and box to an existing toolbar. This iwill allow you to scroll through the various views you have saved, on demand.


The concept you are talking about is related to database type functionality. In Access you could have a saved query that always sorts your list, in the view you want, no matter how much you add. You can acheive this in Excel, as described above.