Conditional Confusion
 

Hey, I need some help. I am working on a macro to prioritize a list of
job orders by ID and then assign them start dates based on lead time.
In the list there are certain jobs that are not applicable. Is there a
conditional statement or function that I could use to hide any row
that has "n/a" in one of its cells??? Please help! Thanks.

Conditional Confusion
 

Apply an autofilter on that column - select Custom from the pull-down
and then "Is not equal to" and type n/a in the other panel, then OK.

Alternatively, in your macro you can read the contents of that cell on
each row and use IF THEN ELSE to avoid the cells that contain "n/a".

Hope this helps.

Pete

On Aug 16, 2:20 pm, wrote:
Hey, I need some help. I am working on a macro to prioritize a list of
job orders by ID and then assign them start dates based on lead time.
In the list there are certain jobs that are not applicable. Is there a
conditional statement or function that I could use to hide any row
that has "n/a" in one of its cells??? Please help! Thanks.