can i automatically copy subtotals in excel to another s/sheet?

  • Thread starter Thread starter Richard Malpas
  • Start date Start date
R

Richard Malpas

I have created two spreadsheets with approx 150,000 rows in each. I have
sub-totalled each sheet and would like to work on the subtotals, applying
filters etc. There are some 10,000 sub-totals in each sheet and I would
prefer to copy them to separate sheets to do any further work. How can I set
it up so that the sub-totals are automatically copied to another sheet,
rather than having to manually copy and paste? I am using Excel 2007 with
Vista Home Premium.

Any thoughts much appreciated.
 
Hi,

There is no automatic way built-in. It only requires one or two manual
steps to copy subtotals, but if you want to automate it turn on the macro
recorder and do the two or three steps.
 
Back
Top