Worksheet problem

P

Postal Bob

I have a work sheet that covers a week that I use daily and at the end of
the week I have to clear the data cells and keep the formulas in the other
cells. I have shared this with others and their only complait is that going
to each cell or row of cells to delete data is a pain (its a large
worksheet). My question is, is there a way to put a command cell on the
worksheet that delets the entered data and leaves the cells with the formulas
in them?
 
D

Douglas J. Steele

Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.
 
H

Harvey Zimberg

Douglas said:
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.
Click to expand...
This is not an Access problem. However, if you save a blank worksheet
and then when you start entering data, just save it under a new name. At
the end of the week, delete this worksheet and open up the original at
the start of the next week.

Harvey Zimberg
 
Top