Wondering if you can help again? I have a macro taken from this site, but need some tweeking to fit my scenario.
All I want is the formula in column H4 to be copied down one row at a time as data is entered in column A4 and down. I think I need a worksheet change event.
the current formula I have is as follows but I don't require all the additional vlookup stuff:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A4:A" & Rows.Count)) Is Nothing Then
If Target <> "" Then
Range("H" & Target.Row).Formula = "=VLOOKUP(LEFT(H" & Target.Row & ",17),'X:\APS 3 MRAP\Processing\Tools\[Tags.xlsx]Sheet1'!$A$2:$H$10000,2,FALSE),"""")"
Range("C" & Target.Row) = ""
Any help would be greatly appreciated.