auto clearing cells

  • Thread starter Thread starter Yvonne
  • Start date Start date
Y

Yvonne

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 ?
 
Yvonne

That's what Templates are used for.

Save your original workbook.........cleared of course........as a File>Save
As>MS 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
 
Back
Top