LinkBack URL
About LinkBacks
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub Cells(Target.Row, 5).Formula = "=vlookup(" & Target.Address & ",Sheet2!$A$5:$B$30,2,FALSE)" End Sub
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C:C")) Is Nothing Then Exit Sub Cells(Target.Row, 5).Formula = "=vlookup(" & Target.Address & ",Sheet2!$A$5:$B$30,2,FALSE)" End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks