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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top