This should be quite a simple project - nearly found some code online but couldn't quite make it work.
I have a table in access with sales by brand and need a a button on the form as well as a drop down for date with "select distinct" dates showing.
When the user selects a date and hits the button, it will separate the table and export into multiple seperate excel files breaking the table down by Brand for the date selected.
On the xl. file name needs to include brand and date and save to a new folder with that date on it.
Please let me know a quote for price and how long it will take. Thanks