VBA Code to copy line of data from one sheet to another in the next empty line

[dwpfreak]

Hi, I need a VBA code that I can run on button click that copies a line of entry from one sheet into the next empty row on the 2nd sheet.

Sheet 1 is income entry
Sheet 2 is Income

The VBA should then clear entry lines from sheet 1

What is key is the code needs to find the destination row that is immediately after the previous entry and copy and past from sheet 1

is this even possible?

 

[mumps]

How do you determine which line to copy? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).