Search results

Maybe. I have it set up under a command button, so all I do is click the button and all of the queries are exported to excel sheets. I want to set up my command button code to automatically filter my queries for the previous month as it exports instead of me going back into each query, filtering...

I can export reports to excel with no problem. However, every time before I export the monthly reports, I have to go through all my filters in my queries and change them to the previous month so all of the data filters accordingly and then export the queries again. How can I get my code to...

I need to export the data into an existing excel sheet and have it overwrite the data that is already there (because these are monthly reports). I have searched around and everyone keeps referring to VBA, but I know basically nothing about it, so can I do this by using a simple macro? If I...