Linking Rows or columns

[deadduck456]

I am not sure weather this is possible or not but i would like to know weather it is possible to link rows so that is you change something in one column it changes it in the other.
Any advice is appreciated,
deadduck456

 

[Marcílio_Lobão]

deadduck456, Good morning.

I'm not sure if I understood well your question.

If you want one cell or row or column be EQUAL at any other cell, row or column it's necessary only to use at a cell that will be changed automatically, a formula.

Origin Cell --> A10
Automatically filled Cell --> C1 receives a formula =A10.
Then all the times you update A10, C1 changes automatically.

Is it what you want?
I hope it helps.
---------------------
Belo Horizonte, Brazil.

 

[deadduck456]

Sort of however I would also like it to be able to, everytime I update C1 for A10 to change also and vice versa

 

[MPW]

You could do something like this:
On the WorkSheet:

Private Sub Worksheet_Change(ByVal Target As Range)
    RangeChange
End Sub

and then in a module

Sub RangeChange()
    Application.EnableEvents = False
    If ActiveCell.Column = 3 Then
        If ActiveCell.Row = 1 Then
            Range("A10") = Range("C1")
        End If
    ElseIf ActiveCell.Column = 1 Then
        If ActiveCell.Row = 10 Then
             Range("C1") = Range("A10")
        End If
    End If
    Application.EnableEvents = True
End Sub

The reason to use the module is because

Application.EnableEvents

does not work well in the workbook or worksheet on event changes.

 

[MPW]

One more thing...

There are 2 weaknesses with using

[COLOR=#333333]Private Sub Worksheet_Change(ByVal Target As Range)[/COLOR]

When one of these cells are changed the change must be finalized by using the [Enter] key.
1. If you finalize your change by clicking another cell with your mouse you just changed the activecell and ir will not run the macro.
2. If the 'Move Selection on Enter' option is active you just changed the activecell and ir will not run the macro. This option is found in the 'Edit' section of your options menu.

Hope this helps