correction
as for the above code
it did exactly what it was coded to do just not what i needed it to do as it permanently stops the table 3 line add because the job cost is a permanent line
i since removed this line all together ( grey line at bottom of table 2 )
changed the code to look for a blank "" instead of " job cost" at the bottom of table 2
Sub Add_New_Line_To_Table_3()
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'only if last line in Table 2 is not JOB COST in column A
Dim ws As Worksheet
Set ws = ActiveSheet
If Sheet3.Cells(Rows.Count, 1).End(xlUp) = "" Then MsgBox "No Line added ": Exit Sub
ws.ListObjects("Table3").ListRows.Add
End Sub
this now properly stops the addition of a new line on table 3 IF and only if i have a blank row on Table 2 at the bottom
so i permanently need the table to always have a blank row at the bottom
so to this effect i need to come up with an event triggered macro to add a new row to the table 2 anytime the last row of current table is populated
this will then allow the (add line ) code for table 3 to properly perform its function
this would then eliminate the need for the ( ADD LINE Code i have for the sheet MAster ESR Data