ExcelBanter - Write subtotals to another sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Write subtotals to another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/17898-write-subtotals-another-sheet.html)

Gerrym

Write subtotals to another sheet

when I apply subtotals to data in a sheet can i write the
results from level 2 to another sheet ?

TKS

Dave Peterson

Show the levels you want to copy (hide the other details).

Create a new worksheet

Back to the subtotal worksheet
Select that range
edit|goto|special
check visible cells only
copy that selection of visible cells.

Paste into that new worksheet.

Gerrym wrote:

when I apply subtotals to data in a sheet can i write the
results from level 2 to another sheet ?

TKS

--

Dave Peterson

All times are GMT +1. The time now is 07:51 AM.