Pivot Table - Copy Rows

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Pivot Table - Copy Rows

FAQ

Thread Tools

Display Modes

02-26-2016, 08:14 AM

theexpat

Windows 7 32bit Pivot Table - Copy Rows

Office 2007

Novice

Join Date: Feb 2016

Posts: 6

Pivot Table - Copy Rows

Please help me on this For the PT attached every time I filter by Cell Zone , there are two rows of interest Total Count & Total Amount

when I filter say for Zone A I want to copy the two rows to new sheet .
then I filter for zone B , I want to copy the new resulting rows to the new sheet below the last ones.

note that every cell in these two rows contains formula.

please help.

PT link.
http://i.imgur.com/Shl0SPg.png?1

Attached Images

PV - rows.png (11.4 KB, 12 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM
Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word?	Joey Cheung	Word Tables	1	08-12-2014 05:15 PM
Average over all pivot rows in excel	Andrey	Excel	2	07-23-2014 07:51 AM
Why cant I just copy/paste new flippin rows into a flippin table?	jethrouk	Word	8	11-17-2013 06:09 PM
Excel Pivot - Do not display rows with zero value	patidallas22	Excel	1	03-08-2013 01:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:13 PM.