Copy relative data to proper worksheet

[KingTamo]

Hi excel experts
In column C from C2 to C100, there are numbers that are greater than zero and zero values and N/A
I wanted to copy the values that are greater than zero to worksheet named "OM" and the values N/A to another worksheet named "ON"
The copy will be for the whole row not only the cells

[JEC.]

Using autofilter

Please Login or Register  to view this content.

[KingTamo]

Thank you so much sir JEC

[JEC.]

You're welcome!