Extract rows from a list of customers with NO turnover in ALL months

Hi, can anyone help me out?
In the attachment you can see a list with customers in sheet 1.
For these customers the TurnOver in pcs and value is noted per month.
Some customers have TO in all months, others don't!

What I need is a vba that copies the rows in sheet 1 for customers that NOT have turnover (pcs and values) in all months and paste it in sheet 2 (see example in attachment)

Your help is appreciated!!

Rgds, Robert

Hi sintek, It works fine! Thanks very much!

Hi Jeffreybrown, this works even finer. Headings are added to. Great!! Thanks for your help.

Rgds, Robert

Hi jeffreybrown, hopefully you can help me once more !
In the script you wrote, all rows with values in all cells are filtered out.
How can I change the autofilter in a way that only the rows with all cells filled will be paste in sheet 3?

So the result is that I have 2 sheets: sheet2 with the result that rows with values in all cells are filtered out
sheet3 with the result that it has only the rows that has values in all cells.

Would be great if you could help!!

Regards, Robert