The Subtotals form provides an option, at the bottom left, which you can checkmark...
"Page break between groups". This will force printing of each group on a
separate page. There is no automatic way to have each group added to
a separate sheet. That requires VBA code.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - two dozen ways to sort with "Special Sort")




"DRayner"
wrote in message
Is there anyway to have Excel autmatically make a new spreadsheet for each
break/change in grouping using the subtotal function? I need to create
subtotals of a payment by ID# and then each ID# needs to be put into a new
spreadsheet so I can email this to the ID owner. Currently I am manually
doing this and it is quite an undertaking. Any help would be great!!