VBA - Copy and Past to last row

[itsgrady]

I tried to make two different MACROS to copy data from one table and paste that information to another table on the last row.

The first VBA was to copy one line from a table and then paste that one line in the last row of a different table.

The second VBA was to copy four rows from one table and paste those four rows in another table on the last row and then delete the four rows from the table that I copied from.

I had no luck in doing this. I was able to copy but was not able to paste.

Is there a simple code to do this?

 

[Legacy 143009]

Hello,

Do you want to keep formatting or are they just values?

 

[itsgrady]

Hello,

Do you want to keep formatting or are they just values?

They are values only.