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.
Bookmarks