Subtotal-new spreadsheet at each break?

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!!
 
J

Jim Cone

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I subtotal specific / random rows from a spreadsheet? 1
HI!Need to make Cell formula change for each Pg Break in a Print T 1
Subtotals and Conditional Formatting 1
Using more than one subtotal with same data set 3
Subtotal Formatting 2
Printing subtotals on each page 9
Insert a new worksheet after subtotal 1
subtotals showing 0 in summary level// 2 subtotal levels 2

Top