Copy cell values, add a new row on table and paste them at the bottom of a table

I have been trying to make sheet take all the information highlighted in yellow on the "check sheet" and moving it to the "log". On this page I want it to add a new row and paste in the data in yellow.

I tried doing a test of the macro that I would use but it does not add an additional row when I use it

Please Login or Register  to view this content.

I just haven't been able to work out how to do this, any help would be appreciated

I believe I may be going about this the wrong way

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.

The "Log" worksheet also contains a "Clear Log" button which will clear all values from the "Log" table, and also reset the dimensions of that table.

This is the cheap 'n' cheerful version of the code which means that the first two rows of the "Log" table will always be empty - some additional code will be required if you're not happy to live with this shortcoming.


Hope this helps - please let me know how you get on.

Regards,

Greg M