Please help on this daily boring task , if it can be done by Macro or Formula.

From ProductName_general field I select Auto
From Productname field i select multiple items (Auto,Auto Balloon,Auto Stepup),
From the Channel fieldDIB,DIBLDY,INB selected.

then from Zone field i select
Zone A
after that what is required is to copy the resulting two rows Total Count , Total amount to new Sheet.

then Zone B
copy the resulting two rows Total Count , Total amount to the same new Sheet. below the two previous rows.
.
.
.
the last Zone G. copy the resulting two rows Total Count , Total amount to the same new Sheet. below the previous rows.



please please assist.

thanks in advance.

Reda.

Attached Images

PTable.png (13.7 KB, 10 views)