i need a macro that automatically runs when data is typed or pasted into cells

[tonywatsonhelp]

hi everyone,

please help ive been playing around with this all morning and getting nowhere

I have 5 columns S:W that take data

when data is put into all 5 of the columns i need to trigger a macro that can run another macro on every row that has been entered,

so to give a bit of background i created an input area and now everyone is pasting in batchs of data instead of just typing it in one row at a time so my macro no longer works,
however if posible what id like is to have a macro that triggers autoomaticly when the data is both typed in or pasted in,

so the macro if it was in english would read,

If data is typed or pasted into columns S,T,U,V or W then
for each row of data typed or pasted in if Column A is empty (i say empty as in contains nothing, as some might have formulas in) then run macro "Fillit"

end sub

so thats it, sounds easy, but i'm have trouble because i dont want it runing if its already put the data in

 

[mart37]

Private Sub Worksheet_Change(ByVal Target As Range)
    startcol = 19
    endcol = 23
    If Target.Column >= startcol And Target.Column <= endcol Then
        EnableEvents = False
        For Each r In Target.Rows
            t = 0
            For Each c In ActiveSheet.Range(Cells(r.Row, startcol), Cells(r.Row, endcol))
                If Not IsEmpty(c) Then t = t + 1
            Next
            If t = (endcol - startcol + 1) And IsEmpty(ActiveSheet.Cells(r.Row, 1)) Then FillIt r.Row
        Next
        EnableEvents = True
    End If
End Sub

 

[tonywatsonhelp]

thank you mart