Subtotal-new spreadsheet at each break?

  • Thread starter Thread starter DRayner
  • Start date Start date
D

DRayner

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!!
 
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!!
 
Back
Top