One major issue that I have found is not VBA related. Your Table(Listobject) extends way beyond the recorded data, so lr is returning 499 in the frmAdd code. Your columns are the same.
I defined the table to range A1:E500 for the sample file I attached here.
But the final table will have even more columns and rows...
If this is a problem then I should tell the code to only look in the occupied cells, but how do I do that?
Thank you again