Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - Sort & Filter by Date
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel vba training - Sort & Filter by Date
Resolved · Low Priority · Version Standard
Reply
Sort & Filter by Date
HiI am using a spreadsheet to prioritse my work by (1) numerical priority 1-3 and (2) by date the job was recieved.
How do I make a parameter so that it is sorted / filtered by these two automatically?
Currently I am using autofilter across the heading names - however, I need to keep filtering each time I add/remove/edit a line.
Please can I find another way of doing this- perhaps by using some of the advanced options or funtion builder. Alternatively, I cannot make the "sort" function understand that I want the oldest date first.
Kind Regards
Sachin Kotak
sachin.kotak@autotrader.co.uk
For upcoming training course dates see: Pricing & availability
RE: 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.
|
 |
|
» Forum post: Excel 2007 |
How NLP Can Make Positive Changes To Your Work Performance Helping your company to rise to greater heights can be achieved easily and effortlessly by a process known as Neuro Linguistic Programming NLP). This technique is used by organizations to help improve their status. From leaders through to sales reps, NLP will teach you the art of human excellence which will help you to become the very best business person you can » Article: Communications course syllabus london |
Creating formulas to link spreadsheet data
