Copy - Paste new line repeat

Hi! first of all i would want to apologize for my bad English and now to the point...

I am working on simple data base in excel 2010 everything is working well but now i am stuck on data save problem basically i need to copy some cells from sheet1 to sheet 2 and arrange in line (a1, a2 , a3 etc)

i figured out the copy part but how do i copy info in next line after activating macro is a mistery to me probably something with offset but i am not sure

if anyone could help please do so

here is what i have in a macro:

Please Login or Register  to view this content.

Welcome to the forum
As the paperclip does not work anymore :

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.