Auto insert worksheets for multiple page imports

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I have an Access database that has a query run to create a
separate page with different Vendor Account number and
related billing account information for each. The vendor
requires this in Excel format but a separate worksheet for
each billing account.
Ex. ABC company has 10 billing accounts with information.
They want 10 different worksheets with the specific
information on each.
I know how to export to Excel but it won't create sep.
worksheets for each page created.
Can this be done?
 
Here's my recommendation:
Download the entire file from access to one excel file and sheet named
Master.
Then use the technique described at:
http://www.contextures.com/excelfiles.html
scroll downward until you come to section: Filters, then number three (3):
Create New Sheets from Filtered List -- uses an Advanced Filter
to create separate sheet of orders for each sales rep visible in a
filtered list; macro automates the filter. Download file and
replace their "sales rep" with your "billing accounts" for your specific
needs.
HTH
 
Back
Top