Hello,
I am not very good at excel to start off with, but trying to learn.
What I am trying to do is hide H2 and I2 (Check boxes) when the part (E2) is not side specific.
E2 is pulling data from another sheet called "parts" which has a column of "Yes" or "No" whether its side specific.
Is there anyway to hide or appear blank when Parts sheet E column is "No"?
This is for work, so I cant upload the document as it has sensitive information but I can send more screenshots if needed. Hopefully this makes sense and someone can assist. Thank you!
I am not very good at excel to start off with, but trying to learn.
What I am trying to do is hide H2 and I2 (Check boxes) when the part (E2) is not side specific.
E2 is pulling data from another sheet called "parts" which has a column of "Yes" or "No" whether its side specific.
Is there anyway to hide or appear blank when Parts sheet E column is "No"?
This is for work, so I cant upload the document as it has sensitive information but I can send more screenshots if needed. Hopefully this makes sense and someone can assist. Thank you!