Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
I have a document set up with IF statements to auto populate redundant
information. For example: the customer bill to address and the customer ship to address. If the information is different they can type over my function- but then it is gone. Is there a way to keep the function there without doing save as each time? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
Use another cell for input. In the cell where it should be, enter a formula like
=IF(A2="",A1,A2) With addresses in A1 and A2. -- Kind regards, Niek Otten Microsoft MVP - Excel "JKeef" wrote in message ... |I have a document set up with IF statements to auto populate redundant | information. For example: the customer bill to address and the customer ship | to address. If the information is different they can type over my function- | but then it is gone. Is there a way to keep the function there without doing | save as each time? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
That is how my statements are set up, they auto populate from the customer
bill to address into the customer site address- but if the address is different, they type in the same box over my function. In your scenario below it would be A2. Is there a way to enter for example cell c2 enter formula: =IF(a2<"",b2=a2,"") this way the actual cell for input (being b2) has no formula to type over. "Niek Otten" wrote: Use another cell for input. In the cell where it should be, enter a formula like =IF(A2="",A1,A2) With addresses in A1 and A2. -- Kind regards, Niek Otten Microsoft MVP - Excel "JKeef" wrote in message ... |I have a document set up with IF statements to auto populate redundant | information. For example: the customer bill to address and the customer ship | to address. If the information is different they can type over my function- | but then it is gone. Is there a way to keep the function there without doing | save as each time? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
What I meant is: If you print your data from C1 and C2, let the user input it in A1 and A2. In C1, use this formula:
=A1 In C2, use this formula: =IF(A2="",A1,A2) -- Kind regards, Niek Otten Microsoft MVP - Excel "JKeef" wrote in message ... | That is how my statements are set up, they auto populate from the customer | bill to address into the customer site address- but if the address is | different, they type in the same box over my function. In your scenario below | it would be A2. | | Is there a way to enter for example cell c2 enter formula: | =IF(a2<"",b2=a2,"") this way the actual cell for input (being b2) has no | formula to type over. | | "Niek Otten" wrote: | | Use another cell for input. In the cell where it should be, enter a formula like | | =IF(A2="",A1,A2) | | With addresses in A1 and A2. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "JKeef" wrote in message ... | |I have a document set up with IF statements to auto populate redundant | | information. For example: the customer bill to address and the customer ship | | to address. If the information is different they can type over my function- | | but then it is gone. Is there a way to keep the function there without doing | | save as each time? | | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
I understand, but the user is entering the information once, maybe twice.
Is there a way to place the results of an IF statement in another cell? Type in cell z1=If(A2<"",c2=a2,c2="") Maybe an IF THEN statement? "Niek Otten" wrote: What I meant is: If you print your data from C1 and C2, let the user input it in A1 and A2. In C1, use this formula: =A1 In C2, use this formula: =IF(A2="",A1,A2) -- Kind regards, Niek Otten Microsoft MVP - Excel "JKeef" wrote in message ... | That is how my statements are set up, they auto populate from the customer | bill to address into the customer site address- but if the address is | different, they type in the same box over my function. In your scenario below | it would be A2. | | Is there a way to enter for example cell c2 enter formula: | =IF(a2<"",b2=a2,"") this way the actual cell for input (being b2) has no | formula to type over. | | "Niek Otten" wrote: | | Use another cell for input. In the cell where it should be, enter a formula like | | =IF(A2="",A1,A2) | | With addresses in A1 and A2. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "JKeef" wrote in message ... | |I have a document set up with IF statements to auto populate redundant | | information. For example: the customer bill to address and the customer ship | | to address. If the information is different they can type over my function- | | but then it is gone. Is there a way to keep the function there without doing | | save as each time? | | | |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
A formula cannot send a value to another cell.
Formulas "pull", they don't "push". Gord Dibben MS Excel MVP On Tue, 9 Sep 2008 14:13:01 -0700, JKeef wrote: I understand, but the user is entering the information once, maybe twice. Is there a way to place the results of an IF statement in another cell? Type in cell z1=If(A2<"",c2=a2,c2="") Maybe an IF THEN statement? "Niek Otten" wrote: What I meant is: If you print your data from C1 and C2, let the user input it in A1 and A2. In C1, use this formula: =A1 In C2, use this formula: =IF(A2="",A1,A2) -- Kind regards, Niek Otten Microsoft MVP - Excel "JKeef" wrote in message ... | That is how my statements are set up, they auto populate from the customer | bill to address into the customer site address- but if the address is | different, they type in the same box over my function. In your scenario below | it would be A2. | | Is there a way to enter for example cell c2 enter formula: | =IF(a2<"",b2=a2,"") this way the actual cell for input (being b2) has no | formula to type over. | | "Niek Otten" wrote: | | Use another cell for input. In the cell where it should be, enter a formula like | | =IF(A2="",A1,A2) | | With addresses in A1 and A2. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "JKeef" wrote in message ... | |I have a document set up with IF statements to auto populate redundant | | information. For example: the customer bill to address and the customer ship | | to address. If the information is different they can type over my function- | | but then it is gone. Is there a way to keep the function there without doing | | save as each time? | | | |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent deleting functions
Thank you. That's my answer.
I'll have to come up with plan B "Gord Dibben" wrote: A formula cannot send a value to another cell. Formulas "pull", they don't "push". Gord Dibben MS Excel MVP On Tue, 9 Sep 2008 14:13:01 -0700, JKeef wrote: I understand, but the user is entering the information once, maybe twice. Is there a way to place the results of an IF statement in another cell? Type in cell z1=If(A2<"",c2=a2,c2="") Maybe an IF THEN statement? "Niek Otten" wrote: What I meant is: If you print your data from C1 and C2, let the user input it in A1 and A2. In C1, use this formula: =A1 In C2, use this formula: =IF(A2="",A1,A2) -- Kind regards, Niek Otten Microsoft MVP - Excel "JKeef" wrote in message ... | That is how my statements are set up, they auto populate from the customer | bill to address into the customer site address- but if the address is | different, they type in the same box over my function. In your scenario below | it would be A2. | | Is there a way to enter for example cell c2 enter formula: | =IF(a2<"",b2=a2,"") this way the actual cell for input (being b2) has no | formula to type over. | | "Niek Otten" wrote: | | Use another cell for input. In the cell where it should be, enter a formula like | | =IF(A2="",A1,A2) | | With addresses in A1 and A2. | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "JKeef" wrote in message ... | |I have a document set up with IF statements to auto populate redundant | | information. For example: the customer bill to address and the customer ship | | to address. If the information is different they can type over my function- | | but then it is gone. Is there a way to keep the function there without doing | | save as each time? | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent deleting multiple cells at once | Excel Discussion (Misc queries) | |||
How can I prevent someone from deleting a shared workbook? | Excel Worksheet Functions | |||
How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) |