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

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.
 
S

Shane Devenshire

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.
 

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 selectand copy only subtotals in a sheet 1
copy subtotals 1
How do I copy, paste subtotals only from an Excel list? 2
Move data from one worksheet to another. 1
Too Few Rows to copy sheet to another book 2
How do I copy subtotals to another sheet? 1
transferring total sheet from one workbook to another 3
copy rows to another file 3

Top