Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting the text without deleting the formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting the text without deleting the formula
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting the text without deleting the formula
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting the text without deleting the formula
Your formulas should be referencing a cell with a constant in it.
Like D1 has a client name. In D4 you enter =D1 Now when you delete the name from D1, D4 formula is not deleted but no longer shows the client's name. Your formulas should be set up so that you never have to delete the cell with the formula. Gord Dibben MS Excel MVP On Fri, 30 Jan 2009 02:39:01 -0800, gems04 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Text | New Users to Excel | |||
is it possible to enter in text over a formula without deleting the formula? | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel |