analyze with excel send grouping to separate tabs in excel

[johnny_ringo]

i need to be able to use the "analyze with excel function" in access for a
report so that when i send the data to excel the groupings found in access
with the query and shown on the report will each export to a separate tab in
an excel spreadsheet