Need help with Excel

[Arline]

I have creating a spreadsheet...when the guys used the
spreadsheet and they have to delete the information that
was on it previously...they always delete the
formulas...I have tried to hide, lock, protect the cells,
and still it is happening. How do I create a spreadsheet
where they can enter their information as they need the
sheet without deleting the formulas...they have to create
a new sheet for all the customers...and all they have to
do is change the old data...for the new. Do I have to
used another program or use some MAcros????I have been
getting lots of headaches over this. Thanks you so much.

 

[Gord Dibben]

Arline

After copying the sheet.

Edit>Go To>Special>Constants. Select what you want to find then OK.

Edit>Clear>Contents. This will leave the formulas.

You could record a macro while doing this.

Gord Dibben Excel MVP