E
Eric Pulliam
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
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