Lock cell as reference not value
 

Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.

Lock cell as reference not value
 

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.

Lock cell as reference not value
 

thanx max ,.....you really did help me. This is my internship project and it
adquire more knowlegde of excell that I what I've tought.

Another Question, How do I formulate a formula to be able to insert rows in
a section and that it will be automatically added to a sum of that section.

With other words: th formula =sum (E13:E15) and I insert 3 more rows an it
had to become =sum(E13: E18)AUTOMATICALLY.

"Max" wrote:

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.

Lock cell as reference not value
 

Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will always
refer to cell A1?

Because If it is like that I've already try it and is not working. it saidf
#VALUE!

help pls

susy

"Max" wrote:

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.

Lock cell as reference not value
 

I can't see the other replies on this thread, but I think you want:

=$A$1/1.82

This will always refer to cell A1, even if you copy it elsewhere.

Hope this helps.

Pete

On Sep 21, 4:18 pm, susy wrote:
Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will always
refer to cell A1?

Because If it is like that I've already try it and is not working. it saidf
#VALUE!

help pls

susy



"Max" wrote:
please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.- Hide quoted text -

- Show quoted text -

Lock cell as reference not value
 

You'd better read Max's post again, Susy.
--
David Biddulph

"susy" wrote in message
...
Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will
always
refer to cell A1?

Because If it is like that I've already try it and is not working. it
saidf
#VALUE!

help pls

susy

"Max" wrote:

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to
lock for
otheruser. but my formulas keep changing if a move, copy or paste a
value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of
my
formulas.

Lock cell as reference not value
 

hi thnx for the post but I figure out my problem with MAX post.

Would you know maybe how to make a formula in which I can include new rows
automatically into a "formula".
example: sum=(A12:A16) I include 3 more rows and automatically it become
sum=(A12:A19)

Susy

"Pete_UK" wrote:

I can't see the other replies on this thread, but I think you want:

=$A$1/1.82

This will always refer to cell A1, even if you copy it elsewhere.

Hope this helps.

Pete

On Sep 21, 4:18 pm, susy wrote:
Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will always
refer to cell A1?

Because If it is like that I've already try it and is not working. it saidf
#VALUE!

help pls

susy



"Max" wrote:
please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.- Hide quoted text -

- Show quoted text -

Lock cell as reference not value
 

=SUM(A12:INDEX(A:A,ROW()-1))



Gord Dibben MS Excel MVP


On Wed, 26 Sep 2007 12:10:03 -0700, susy wrote:

hi thnx for the post but I figure out my problem with MAX post.

Would you know maybe how to make a formula in which I can include new rows
automatically into a "formula".
example: sum=(A12:A16) I include 3 more rows and automatically it become
sum=(A12:A19)

Susy

"Pete_UK" wrote:

I can't see the other replies on this thread, but I think you want:

=$A$1/1.82

This will always refer to cell A1, even if you copy it elsewhere.

Hope this helps.

Pete

On Sep 21, 4:18 pm, susy wrote:
Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will always
refer to cell A1?

Because If it is like that I've already try it and is not working. it saidf
#VALUE!

help pls

susy



"Max" wrote:
please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.- Hide quoted text -

- Show quoted text -

Lock cell as reference not value
 

Thnx very much it work just the way I wanted to.

susy

"Gord Dibben" wrote:

=SUM(A12:INDEX(A:A,ROW()-1))



Gord Dibben MS Excel MVP


On Wed, 26 Sep 2007 12:10:03 -0700, susy wrote:

hi thnx for the post but I figure out my problem with MAX post.

Would you know maybe how to make a formula in which I can include new rows
automatically into a "formula".
example: sum=(A12:A16) I include 3 more rows and automatically it become
sum=(A12:A19)

Susy

"Pete_UK" wrote:

I can't see the other replies on this thread, but I think you want:

=$A$1/1.82

This will always refer to cell A1, even if you copy it elsewhere.

Hope this helps.

Pete

On Sep 21, 4:18 pm, susy wrote:
Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will always
refer to cell A1?

Because If it is like that I've already try it and is not working. it saidf
#VALUE!

help pls

susy



"Max" wrote:
please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"susy" wrote:
Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.- Hide quoted text -

- Show quoted text -