niyrho
09-08-2008, 12:25 PM
I'm making an inspection report. I want some feilds on it to default to a certain value. Its layed otu like:
column B is Device type
column C is Location
column H is zone
column I is Pass/Fail
column J is hight
I need a code that will, if column B is anything other than blank then column I in the same row will default to "Pass" and column J in the same row will default to "No". I still want the option of changing them after they go to their default values. This is just to save time.
I don't know if it will affect it, but I'm using data validation for a dropdown list in columns B,I and J.
column B is Device type
column C is Location
column H is zone
column I is Pass/Fail
column J is hight
I need a code that will, if column B is anything other than blank then column I in the same row will default to "Pass" and column J in the same row will default to "No". I still want the option of changing them after they go to their default values. This is just to save time.
I don't know if it will affect it, but I'm using data validation for a dropdown list in columns B,I and J.