Hi

I'm trying to write a bit of vba to copy data into a table and then insert a row underneath it. At the moment I've got this;

Please Login or Register  to view this content.
But instead of inserting "test" I want the vba to copy over data from another sheet onto a new one. Can anyone help?

Thanks :D