Remember Me?

#1
May 17th 05, 06:25 PM
 Sam Posts: n/a
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
May 17th 05, 07:43 PM
 Gord Dibben Posts: n/a

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
May 18th 05, 02:31 AM
 Sam Posts: n/a

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
May 18th 05, 10:57 PM
 Gord Dibben Posts: n/a

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 05:57 AM.