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.