This video tutorial details the VBA code needed to add a record to an existing Excel Table and then enter data into that new record.
------------------------