I, for one, do not get it. It seems that your data layout is
Company --|-- Party ID
xxxx --|-- x1
--|-- x2
yyyy --|-- y1
--|-- y2
Under such layout how company would align with the data. and if all you want is to copy the valid party id from sheet2, then apply the filter and copy the data.