custom autofilter
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Custom Autofilter

Custom Autofilter

resolvedResolved · Urgent Priority · Version 2003

replyReply Tue 3 Jun 2008, 16:20Delegate Rebecca said...

Rebecca has attended:
Excel Advanced course

Custom Autofilter

How do I write code to implement a custom autofilter to display data that falls between two dates.

I would like to put the code into a user form so the user can select dates they want to show on the report.

Many thanks

Becky

For upcoming training course dates see: Pricing & availability

replyReply Wed 4 Jun 2008, 09:48Trainer Amanda said...

RE: Custom Autofilter

Hi Rebecca

Thank you for your question.

As resolving your question would require writing a reasonably detailed script, we suggest one of two possible options:

- We can provide training or consulting services to resolve this issue; and any other coding you may want to learn/implement;

- Attend our 2 day Excel VBA course, which includes a section on Working with Forms and Controls amongst other topics.
The course syllabus is available on the following page:
www.microsofttraining.net/excel-course-in-london-2003-vba.php

If you have any further questions regarding training or consulting services, please call us on phone number; or email info

Kind regards
Amanda

 

Please browse our web site to find out more about
application development excel and other Microsoft training courses.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard