+ Reply to Thread
Results 1 to 2 of 2

Advanced filter to sort date range

  1. #1
    Registered User
    Join Date
    04-03-2010
    Location
    Orlando, FL
    MS-Off Ver
    Office 365
    Posts
    94

    Advanced filter to sort date range

    Hello, I have an Access database that has a query which outputs financial transactions. I have connected this to an Excel worksheet, and I would like the (not computer savvy) user to be able to filter by date range. I want to do this as user-friendly as possible, so I was thinking to make a user form where the user could select a start and end date range, and then with those dates, apply an advanced filter to copy the data to another worksheet. I can handle the userforms and calendars, but the advanced filter date range has me puzzled. Any tips?

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Advanced filter to sort date range

    Autofilter would work?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Advanced filter to sort and sum data
    By wpryan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2015, 11:59 AM
  2. VBA code to sort range alphabetically once run an advanced filter
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2014, 07:33 PM
  3. Advanced filter by date range, international date format problem
    By Senator685 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2013, 08:16 AM
  4. [SOLVED] need advanced filter or Sort by values
    By raw_geek in forum Excel General
    Replies: 4
    Last Post: 05-25-2012, 10:15 PM
  5. advanced filter sort of
    By sponger in forum Excel General
    Replies: 2
    Last Post: 01-30-2007, 07:26 PM
  6. Advanced filter a dynamic date range
    By oneandoneis2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2006, 03:57 AM
  7. [SOLVED] advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1