How to make a different cell equal active cell

**Jaron_t** · 11-27-2012, 05:26 PM

Hi,
I'm looking for a way to do the following:
when I click on a cell in the active sheet, I want a different sheet in the workbook to have one single cell that equals the cell i just clicked, no matter where it may be.

thanks for the help if you can.

**TMS** · 11-27-2012, 05:44 PM

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
Sheet2.Range("A2") = Target.Value

End Sub

Regards, TMS

**Jaron_t** · 11-27-2012, 05:52 PM

Thanks. Now, the actual sheet names I have are different, so I tried modifying as follows:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
Sheet("Employee Info").Range("N1") = Target.Value

End Sub

Evidently thats not right.

**Jaron_t** · 11-27-2012, 05:53 PM

Oh wait, here it is:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
Worksheets("Employee Info").Range("N1") = Target.Value

End Sub

That works, thanks for the help.