Create seperate excel worksheet for each change in Access Producer

[Guest]

I have an Access 2000 Table with Producer, State, Line of Business, Client
name, Totals, and up to 12 monthly totals (M-01 thru M-12). I need to export
this table into a excel spreadsheet and create a new worksheet (tab) for each
new producer.
And if possible, have the Producer name be the label on the worksheet tab.

I do not know VB, but can learn if there is coding to be done. Thanks in
advance for your great site!

 

[Guest]

Sorry I found the solution on Excel site! I export to Excel and then use VB
Micro to read each Producer into a new worksheet! Thanks for your hep though!