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