Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r = 1 And Target.Count = 1 Then
With Sheets(2)
.Range(.Cells(2, c), .Cells(2, c).End(xlDown)).Copy
End With
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r, c
r = Target.Row: c = Target.Column
If r = 1 And Target.Count = 1 Then
With Sheets(2)
.Range(.Cells(2, c), .Cells(2, c).End(xlDown)).Copy
End With
End If
End Sub