How to copy rows based on multiple criteria from one worksheet to another ?

In the open Excel workbook I have two worksheets. I need to copy rows from the first worksheet selected by multiple criteria (e.g. A="1+J", C= NOT ("tree" OR "rock") and E>100) to empty second worksheet. I need to copy just the adjacent columns A to Q values not the whole rows. The number of rows in the first worksheet is known. Any idea ?

Hi Glenn,

Thank you. If I need just to count selected rows I use following formula (not VBA):

=COUNTIFS('Worksheet 1'!$D$2:$D$981;"<100";'Worksheet 1'!$K$2:$K$981;"1 rok";'Worksheet 1'!$N$2:$N$981;"1+J";'Worksheet 1'!$R$2:$R$981;"<>1";'Worksheet 1'!$J$2:$J$981;">42004";'Worksheet 1'!$S$2:$S$981;"stand";'Worksheet 1'!$P$2:$P$981;"<>neprodlouženo";'Worksheet 1'!$P$2:$P$981;"<>ukončeno")

Note I have already extracted all rows from the (sample) Table they do not match the above criteria.

I need a VBA solution.

Dan