Yvonne

That's what Templates are used for.

Save your original workbook.........cleared of course........as a FileSave
AsMS Excel Template(*.xlt)

Users click on open for this template..........a copy is opened.

Users fill that in and save as a file.

Original is never touched.


Gord Dibben MS Excel MVP

On Mon, 14 Jul 2008 13:06:00 -0700, Yvonne
wrote:

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 ?