When ever I do this the value does not stay constant. I think a better way
of explaining my problem is to tell you how I use to do what I want to do in
excel 2003.

I have a summary sheet that adds up all the monthly project expenses which
are entered on another work sheet. Sometimes another worksheet in a
different workbook. I would click on the "destination" cell 1)type the sign
= 2) then I would just click on the source cell within the same sheet, or
worksheet of same file or cell in a whole different work book.

So when ever I added hours of time on one worksheet it would update the
summary expense sheet. There's got to be a simple way of doing this.
Everytime all the cells below the updated cell change or act as if I want
them to copy a range of numbers. Please help - I got to get this new project
summary expense workbook to work.
Thanks!

"NDBC" wrote:

Say the first cell is A1 and the second cell is D1. In D1 type =A1.



"b46ygurl" wrote:

Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?