well basically what it is, is a schedule...so when we have a client come in
the 1st wed of month, then we want to schedule them on the 1st wed of every
month. So if a client cancels, and we delete their name in, lets say, April,
then the formula will be deleted in that cell. How do I make sure that if
they delete the clients name the formula won't be deleted???

"Gary''s Student" wrote:

If you have some cells that have formulas and other cells that have text.
Lock the formula cells and then protect the worksheet.
--
Gary''s Student - gsnu200829


"gems04" wrote:

I have input formulas into 4 worksheets in 1 workbook. For example in
worksheet 1 I have it so D4 automatically populates into D100 and D175, not
only in the 1st worksheet but also in the2nd, 3rd and 4th worksheets. The
problem, maybe with my formula, is if someone where to delet the text in the
2nd worksheet in D100 it'll delete the formula. I need to make sure that if
they delete the text the formula will not be deleted.

Is there a way to make sure that doesn't happen? Or is my formula wrong?

Maria