![]() |
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 |
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 |
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