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.