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.

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

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

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

Thanks I will give that a try

"Dave Peterson" wrote:

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