Conditional Confusion

J

jneaves

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.
 
P

Pete_UK

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
 
Top