Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to change a formula in one cell and have these changes appear
I have the same formula entered in cells A2:A60000, as in cell A1.
However, when I change the formula in A1, I have to (again) copy it into A2:A60000. Is there a way to avoid this - is it possible to change the formula in A1 and have it automatically changed in A2:A60000? Thanks a lot! |
#2
|
|||
|
|||
Peo
Formula in A1:A60000 is =326 * Q1(incremented) Change A1 to =426 * Q1 Must re-copy in A2:A60000, yes? Gord On Tue, 17 May 2005 10:15:21 -0700, "Peo Sjoblom" wrote: Put =A1 in the other cells although I can't understand why you would need the same formula in 60000 cells!? Regards, Peo Sjoblom "Sam" wrote: I have the same formula entered in cells A2:A60000, as in cell A1. However, when I change the formula in A1, I have to (again) copy it into A2:A60000. Is there a way to avoid this - is it possible to change the formula in A1 and have it automatically changed in A2:A60000? Thanks a lot! |
#3
|
|||
|
|||
Hello Peo,
Put =A1 in the other cells although I can't understand why you would need the same formula in 60000 cells!? I meant to say what Gord said: if B1 = 100*A1, and B60000=100*A60000. If I want to change B1 to B1=A1/C1, is there a way not to have to recopy this new formula to cells B2:B60000? |
#4
|
|||
|
|||
Sam
Someone made a good suggestion of entering the new formula in B1 then in Name Box type B1:B60000 and ENTER then F2 and hit CTRL + ENTER. Or you could use a macro. Enter the new formula in B1 then run this. Sub Auto_Fill() Dim lrow As Long With ActiveSheet lrow = Range("A" & Rows.Count).End(xlUp).Row Range("B1:B" & lrow).FillDown End With End Sub Gord On Tue, 17 May 2005 18:31:01 -0700, Sam wrote: Hello Peo, Put =A1 in the other cells although I can't understand why you would need the same formula in 60000 cells!? I meant to say what Gord said: if B1 = 100*A1, and B60000=100*A60000. If I want to change B1 to B1=A1/C1, is there a way not to have to recopy this new formula to cells B2:B60000? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|