ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cut and Paste Data in a Pivot Table (https://www.excelbanter.com/excel-worksheet-functions/6720-cut-paste-data-pivot-table.html)

Moz

Cut and Paste Data in a Pivot Table
 
Is there a way to cut and paste data from a pivot table to a new worksheet.
When I try to do this the cut and paste options are not available?
--
Moz

Frank Kabel

Hi
AFAIK this is not possible. But why do you want to 'cut' anyway?

--
Regards
Frank Kabel
Frankfurt, Germany

"Moz" schrieb im Newsbeitrag
...
Is there a way to cut and paste data from a pivot table to a new

worksheet.
When I try to do this the cut and paste options are not available?
--
Moz



Moz

Because I haven't yet learned how to assimilate multiple grand totals from
multiple pivot tables. I use a pivot table to grab daily results of our
Parts inventory. I have had remarkable improvement and wanted to give a snap
shot of the improvement by Grand Totals over a 20 day period.

"Frank Kabel" wrote:

Hi
AFAIK this is not possible. But why do you want to 'cut' anyway?

--
Regards
Frank Kabel
Frankfurt, Germany

"Moz" schrieb im Newsbeitrag
...
Is there a way to cut and paste data from a pivot table to a new

worksheet.
When I try to do this the cut and paste options are not available?
--
Moz





All times are GMT +1. The time now is 07:17 PM.

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