Hi All
I've been looking through out the board but haven't been able to find an answer so I'm posting a new question to an old problem.
On Sheet1 I have two Ranges (Range1 in column A and Range2 in Column i)
On Sheet2 I have a validation list in cell c1 that pulls data from Range1
When a selection in c1 is made I'd like cell f4 to pull the corresponding entry from Range2 .
Here's what I have so far That doesn't work
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$1" Then
Range("F4").Activate
ActiveCell = Cells(Target.Offset(0, 9))
End If
End Sub
Any help would be greatly appreciated.
Thanks
s
I've been looking through out the board but haven't been able to find an answer so I'm posting a new question to an old problem.
On Sheet1 I have two Ranges (Range1 in column A and Range2 in Column i)
On Sheet2 I have a validation list in cell c1 that pulls data from Range1
When a selection in c1 is made I'd like cell f4 to pull the corresponding entry from Range2 .
Here's what I have so far That doesn't work
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$1" Then
Range("F4").Activate
ActiveCell = Cells(Target.Offset(0, 9))
End If
End Sub
Any help would be greatly appreciated.
Thanks
s