Hello,
I would like to export a query to Excel. We have one column in the query that we use for grouping results (i.e. regions such as "North", "South", etc.).
What I would like to do is for every region (i.e. "North", "South") take the results and export them to a separate tab within an Excel workbook. So, in the end, I would find a "North" tab with all results related to the north region and likewise for the "South" region.
I know some VBA, but I just don't know the code for completing such a task.
Thanks!