Export query to Excel but new tab for each sales rep

[geanswerman]

I need to create an export to Excel for a sales report but each tab should
list each sales rep. The file name will does not have to change but each
month the sales reps may change or sales areas may not have a sale rep yet
assigned ie null.

Thanks for any help.

 

[Ken Snell]

See this article:

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate Worksheets within one EXCEL file via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSameFile