Hi,
Unsure of best way to achieve this but I'm thinking with a for each loop.
Copy each row in Range(A10:H5000) if value in Column P is 0 to a new sheet
Example if just P22, P36, P80:P100 contain a 0 then copy:
A22:H22
A36:H36
A80:H100
Thanks for any help