Stopping a constant variable cell from being copied.
 

Let's say I have a constant variable in cell A1

Then let's say that C1 = B1+A1, and C2 = B2+A1, and C3=B3+A1.

Well if I want to copy C3 and paste it into C4 to C50, Excel will add to the
A1 cell (eg. C4=B4+A2, etc), but I want that to be a constant variable (like
an interest rate).

How can I 'lock it in' so that when a reference of it is copied, the
reference remains the same?

Any advice gratefully received.

Cheers,
Link.

Stopping a constant variable cell from being copied.
 

Put instead in C1: =B1+$A$1
Copy down. The dollar signs in $A$1 will fix it to A1 as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Link" wrote in message
...
Let's say I have a constant variable in cell A1

Then let's say that C1 = B1+A1, and C2 = B2+A1, and C3=B3+A1.

Well if I want to copy C3 and paste it into C4 to C50, Excel will add to
the A1 cell (eg. C4=B4+A2, etc), but I want that to be a constant variable
(like an interest rate).

How can I 'lock it in' so that when a reference of it is copied, the
reference remains the same?

Any advice gratefully received.

Cheers,
Link.

Stopping a constant variable cell from being copied.
 

Perfect! And so easy! Thanks very much Max, I wish I had asked this months
ago!;-)

Cheers,
Link.


"Max" wrote in message
...
Put instead in C1: =B1+$A$1
Copy down. The dollar signs in $A$1 will fix it to A1 as required.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Link" wrote in message
...
Let's say I have a constant variable in cell A1

Then let's say that C1 = B1+A1, and C2 = B2+A1, and C3=B3+A1.

Well if I want to copy C3 and paste it into C4 to C50, Excel will add to
the A1 cell (eg. C4=B4+A2, etc), but I want that to be a constant
variable (like an interest rate).

How can I 'lock it in' so that when a reference of it is copied, the
reference remains the same?

Any advice gratefully received.

Cheers,
Link.

Stopping a constant variable cell from being copied.
 

welcome, glad to help.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Link" wrote in message
...
Perfect! And so easy! Thanks very much Max, I wish I had asked this months
ago!;-)

Cheers,
Link.