look in several sheets and copy rows depending on ..

hi
a member kindly provided me with the below for copying over rows from several sheets where column F had #N/A in there,

could someone help with copying rows where column H has a value that is greater than 0.02

thank you!

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

thanks for the reply, i get type mismatch at

Please Login or Register  to view this content.

ah there is a possibility there are #N/A in the column too, thanks

ive added error resume next, and it appears to be doing what i want, however it brings through the #N/A ones too
thanks

sorry! i need if its less than -0.2 too , if u could advise? thanks

Can you provide a sample sheet with some dummy data?