| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto clearing cells
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 ? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
auto clearing cells
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB Code for clearing Cells | Excel Discussion (Misc queries) | |||
| clearing cells | Excel Worksheet Functions | |||
| Clearing unlocked cells | Excel Discussion (Misc queries) | |||
| Clearing all Active Cells | Excel Worksheet Functions | |||
| Clearing Cells | New Users to Excel | |||
Linear Mode
