Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Export query to Excel but new tab for each sales rep
0 views
Skip to first unread message
geanswerman
Dec 7, 2009, 10:10:01 AM12/7/09
to
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.
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
Dec 7, 2009, 10:59:21 PM12/7/09
to
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
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"geanswerman" <geans...@discussions.microsoft.com> wrote in message
news:04A45E01-9E3D-44FF...@microsoft.com...
0 new messages