Linking two cells

  • Thread starter Thread starter b46ygurl
  • Start date Start date
B

b46ygurl

Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?
 
I just realised you would probably want it to work both ways. My way only
makes d1 = a1 when a1 is changed, not the other way around as well. I don't
think I can make it work both ways. Sorry for jumping in early.
 
---Using formulas you can link one cell to another. In B1 use the formula
=A1
to link B1 to A1...Any changes made to A1 will be reflected in B1

---If you are looking to reflect changes made in A1 and B1 to reflect in
both cells you will need to use a macro. Right click the sheet tab >view code
and paste the below code.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then _
Range("B1") = Range("A1")
If Not Application.Intersect(Target, Range("B1")) Is Nothing Then _
Range("A1") = Range("B1")
Application.EnableEvents = True
End Sub


If this post helps click Yes
 
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!
 
Works exactly the same in 2007

But............you may have two instances of Excel running with a workbook
open in each.

These will not communicate with each other and you can only copy values.

Close the one workbook and that instance of Excel.

Open both workbooks in the same instance/session.


Gord Dibben MS Excel MVP
 
Back
Top