+ Reply to Thread
Results 1 to 1 of 1

Multiple Autofilter Date Criteria on Userform using DSUM arguments

  1. #1
    Registered User
    Join Date
    05-16-2011
    Location
    Virginia Beach, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    22

    Post Multiple Autofilter Date Criteria on Userform using DSUM arguments

    I've undertaken a huge task in tracking missions for a customer with a large list of fields (A:AE). I know that it would be much better to capture this in Access however the customer wants to stick with Excel (familiarity). That said, I've developed a simple user form that the customer can quickly retrieve data (Hours, # of missions, etc) by interfacing the userform with the DSUM function at the top of the data sheet. This all works easy enough but now they would like to be able to pick specific start and stop dates as a criteria. I'm not sure how to integrate a multiple autofilter criteria within a DSUM function and also enable the feature on a userform. I've attached a project file with code for a clearer understanding of how I've done this. I suppose I could create another duplicate Date column but that would increase the size inefficiently. Thanks in advance for any advice/help.
    Attached Files Attached Files

+ 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. DSUM Multiple Criteria
    By Neil Guyton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2014, 12:07 PM
  2. DSUM where criteria is Current Date
    By Magerator in forum Excel General
    Replies: 2
    Last Post: 06-08-2011, 07:44 AM
  3. DSUM: Multiple Criteria
    By NSTAR in forum Excel General
    Replies: 1
    Last Post: 03-31-2010, 10:16 AM
  4. dsum on multiple criteria
    By myroz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-15-2008, 09:33 AM
  5. DSUM using Autofilter with fixed criteria
    By Simon_Aitchison in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2008, 08:39 AM

Tags for this Thread

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