| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Project a formula result from change
Help Please
is there a way i can create a macro that will do the copy and paste value when a result cell has a value in it? ie Cell E1 has the formula =if(D1=A1,B1,0) E2 =if(D2=A1,B1,0) what i want to do is if E1 contains a result value stop it from changing if the value in A1 is changed - i dont want to have to use the copy and paste value every time. Please help this is driving me insane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Result Change when Workbook Sent by E-mail | Excel Discussion (Misc queries) | |||
| Need a formula to change data result weekly. | Excel Worksheet Functions | |||
| Protect the formula but change result. | Excel Worksheet Functions | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Threaded Mode
