Write to a New Spreadsheet

D

Daniell

I have a workbook that the first worksheet has all the information needed to
create a report. What I would like to do is use the SUBTOTAL function and
place the totals on a different sheet. Is this possible? Thanks for any
help in advance.
 
D

Dan

It is easier to use Pivot Table. Otherwise you need to "SUMIF" function. to
build up the next worksheet.
 
D

Dave Peterson

I like the data|pivottable suggestion, too.

But after you apply the subtotals, you can hide the rows you want--just use the
outlining symbols on the left.

Then select the range
edit|goto|special|click visible cells
edit|copy
paste into that other sheet
 
D

Daniell

Thanks I will give that a try

Dave Peterson said:
I like the data|pivottable suggestion, too.

But after you apply the subtotals, you can hide the rows you want--just use the
outlining symbols on the left.

Then select the range
edit|goto|special|click visible cells
edit|copy
paste into that other sheet
Click to expand...
 
Top