I have a checklist in excel. For each question the person filling it out must
choose Yes No or NA (all checkboxes created from Control Toolbox). For all NA
answers the person must give a reason on sheet 3 that I renamed NA
Clarification. Is there a way to make it so that when someone checks the box
for NA it automatically goes to the NA Clarification sheet (sheet 3)? I don't
know if there is a hyperlink or formula I can put in for that? Please help.
Thanks in advance.