How to Copy and paste the entire row which is equal to the sumproduct count values.

I have 5000 lines of data. I was able to count values using sum product function in a required way. But now that I was able to count the data from 5000 lines. I wanted to copy the entire row which matches the sumprodct function and paste it to a different sheet. Could any one please help me. Thank You in advance. I am in very urgency, please help my day.

Hi, Is there any reason why you cant use the filters
Thanks/VKS

=SUMPRODUCT((LEFT(Table1[Affected Items.Item Number],2)="SD")*OR((Table1[Affected Items.Item Type]="SKU"),(Table1[Affected Items.Item Type]="Part"))*(Table1[Affected Items.Item Product Lines]=B4))-(D4+E4+F4)-SUMPRODUCT(ISNUMBER(SEARCH("TEST",Table1[Affected Items.Item Number],1))*OR((Table1[Affected Items.Item Type]="SKU"),(Table1[Affected Items.Item Type]="Part"))*(Table1[Affected Items.Item Product Lines]=B4))

This is the forumla I used to count the data.