Deleting/Copying from Pivot Table
I have got my row labels and count being used in a pivot table. In each row label cell there is a data that can be expanded. In this expanded data is 3 more cells worth of data. I am only wanting the 1 bit of data from each of the expanded cells. I have tried copying the data i'd want from the pivot table but it would not let me and I've tried deleting the areas that i don't need but it won't let me delete them from the pivot table.
I have copied the data out of the pivot table in to a separate sheet but when i do that, it takes away the ability to expend the cells to see the extra information i am after OR it has all of the expanded cells with everything else meaning i can't tell which bits of data has been expanded.
I know that doesn't make much sense and i only know basic excel skills, anyone able to make any sense of that and come up with an answer?
Re: Deleting/Copying from Pivot Table
Can you please share the details in excel will surely help you ,
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Glade1825 in forum Excel Programming / VBA / Macros
Last Post: 03-01-2015, 09:42 PM
By JamesHammer92 in forum Excel Charting & Pivots
Last Post: 11-25-2014, 04:43 AM
By Vickii in forum Excel General
Last Post: 09-14-2009, 03:45 AM
By JChandler22 in forum Excel Programming / VBA / Macros
Last Post: 07-02-2007, 01:42 PM
By Robert Hamilton in forum Excel Formulas & Functions
Last Post: 06-07-2006, 02:45 PM
By Accountant Williams in forum Excel General
Last Post: 09-28-2005, 08:05 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1