copy visible cell and exclude subtotal

Hi!

On sheet1 i have inventory for items named as table1. Table1 is sorted by item nos.
For each item there are some records hidden and for each record there is a subtotal before new item.

Is there a way to copy whole table to another sheet but i don't want to copy subtotal formula for each item. i know how can copy visible cell but it also copy subtotal formula.

Thanks in advance