copy rows based on specific field value
 

Q5I am trying to create a macro that will copy specific fields from 1
spreadsheet to another, based on certain criteria.

Example. Copy cells A5 - I5 from current spreadsheet to new spreadsheet
only if cell B5 0.

At the same time I need to copy cells L5 to T5 from current spreadsheet to
new spreadsheet only if cell Q5 0

Need to do this for all rows in the spreadsheet.

How do you accomplish this??