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