Question: how to copy subtotals in excel to another sheet?
Answer: After subtotalling, click on the 2 square on the left to just see the subtotal lines. Highlight the subtotal lines you want to copy. Press F5 on your keyboard, click Special, and choose Visible Cells Only. Click OK. Then click Copy, and Paste the lines to a new location.