ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data-Subtotals (https://www.excelbanter.com/excel-discussion-misc-queries/163271-data-subtotals.html)

JCM

Data-Subtotals
 
After I have used the subtotal feature under the data list, how can I copy
just the subtotals over to another workbook or worksheet?

Dave Peterson

Data-Subtotals
 
Select the range to copy
Edit|goto|special|Visible cells only
Edit|copy


JCM wrote:

After I have used the subtotal feature under the data list, how can I copy
just the subtotals over to another workbook or worksheet?


--

Dave Peterson


All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com