i have a worksheet that has questions and answers... prior to filling out
answers a job number is typed into a cell .... once done sheet is saved.
my question - if a saved sheet is pulled up and job number is changed.....
how can i have all previous questions "answers" cleared unless original job
number is re-entered ?