Vba Filter

[leader2k]

Vba filter
Hi I use function filtering one combination at time , using the sumproduct/countif function, and I do the filtering manually,it’s time consuming when you have hundreds of thousands of rows, I will appreciate, if a gentleman/women could provide me with Vba macro that compare row Q1:V1 to A12:F12, & loop through A13:F13, A14:F14………and copy the rows that match 4,5,or 6 cells value, to another sheet, and do the same for Q2:V3 to A12:F12, & loop through A13:F13, A14:F14………// Q4:V4 to A12:F12, & loop through A13:F13 ,A14:F14………so forth and so on (Attached sample)