Vba filter
Here is a sample ,I use for filtering one combination at time , using the sumproduct/countif function, and I do the filtering manually as it’s shown on my sample,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,A13:F13,A14:F14………and copy the rows that match 4,5, or 6 to another sheet, and do the same for Q2:V3 to A12:F12,A13:F13,A14:F14………// Q4:V4 to A12:F12,A13:F13,A14:F14………so forth and so on
Here is a sample ,I use for filtering one combination at time , using the sumproduct/countif function, and I do the filtering manually as it’s shown on my sample,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,A13:F13,A14:F14………and copy the rows that match 4,5, or 6 to another sheet, and do the same for Q2:V3 to A12:F12,A13:F13,A14:F14………// Q4:V4 to A12:F12,A13:F13,A14:F14………so forth and so on