To copy subtotal into another sheet

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

How I can copy Subtotal only into another sheet. Now Whenever I am copying
,entire data will go to next sheet. So please let me know to copy the
subtotal data only to another sheet

Thanks
Pol
 
Hi,
Hide the detail rows
Select the range you want to copy
Edit>Goto>
Click the [Special Cells] button
Select: Visible Cells

Go to where you want to copy the information

Edit>Copy

If this was helpful please say yes, thank you
 
if you want the subtotal to update on the 2nd sheet if you modify the data
on the original sheet -- you should just put a link in the cell of the 2nd
sheet to the subtotal cell in your first sheet.

does that make sense to you?
 
Back
Top