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