Hi,

I would be much appreciated if you can help me how to set the code. I know
how to use Subtotal and filter 2 for subtotal and copy to other worksheet by
manually. Is there a way to set macro automatic to hit to copy to other
worksheet with subtotal and grand-total only without detail records.

YOur help much appreciated.
Thanks