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

Daniell wrote:

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.

--

Dave Peterson