Subtotals to separate sheets?

I have a report I create weekly that is about 50,000 lines. It is requested
that they be subtotalled by one of the columns (making about 30 subtotals).
I then have to make a separate sheet for each of these 30 subtotals within
the workbook and paste the contents of each subtotal in each sheet(still
leaving the master totals page). I have to create one of these for 03 04 05
and 06 each week so I need to know if there is a way to subtotal to separate
sheets because copying and pasting is where all my time is spent. Thanks!
Eric

Hi Eric

Have the same issue how did you resolve this?

That thread was posted some TWELVE years ago - I doubt if Eric is still monitoring it.

It would be better to start your own thread, giving details of your own problem.

Hope this helps.

Pete