Copy and paste data in to next blank row of a table

Thanks Millz, that code does not work if there is no data in the table already and it only copies the first row from the ExceptImport table. I have attached a sample file which well help understand what I am trying to achieve.

On the Exceptions Import sheet, I have an XML table that imports data from an XML file. I then need to copy the data as follows:

From Sheet - Exceptions Import, Table ExceptImport, JobNumber column to Sheet - Exceptions, Table ExceptionsTable, JOB NO column
From Sheet - Exceptions Import, Table ExceptImport, Time column to Sheet - Exceptions, Table ExceptionsTable, Time column
From Sheet - Exceptions Import, Table ExceptImport, Comment column to Sheet - Exceptions, Table ExceptionsTable, Comments column
From Sheet - Exceptions Import, Table ExceptImport, ShortCode column to Sheet - Exceptions, Table ExceptionsTable, Error Code column

This is part of a larger file that is created once a week, I need to be able to copy that data to ExceptionsTable if it already has data in it or if it's blank.

Hi Millz

I did not get chance to work on this again until today but that works perfectly. Thank you very much for your help