1) Row1 needs to be your titles, data starting in row2
2)You should consider just putting a formula in Q2 and copying down that will give you a YES when A:F are filled.
=IF(COUNTA(A2:F2)=6, "Yes", "No")
3) The following macro will apply an AutoFilter to your sheet using row1 titles. It will filter Q for "Yes", then it will filter A:F to show only the rows that have values in all 6 columns. Then it will copy the data remaining visible.
4) Optional, we could add where it deletes the rows from the mfr_list after they are copied to the COMPLETE sheet.
5) Truth be told, since this macro is checking the columns A:F for you, maybe you don't really need the YES thing in Q at all.
Bookmarks