Copy Multiple Column Data from Last row excluding header into worksheet in same workbook

I need to copy 20 columns of data using complete columns length excluding header into worksheet in same workbook and place the copy data uniquely in columns under last used row but only paste values I worked on the code below but don't know how to only paste values. I also noticed that the code recognized the last used row, but still went up one and overwrote the last used row. Can I add a paste values function to what I have or declare the copy or pste function as a value somewhere else

Please Login or Register  to view this content.

HI PCI
Thank You for the help. I had to adjust slightly. I'm assuming the (1,2) you had in the code was row & column. When I flipped them it inserted properly. I also had to remove the additional.End(xlUp) code. Even though it was set as LastRow it would recalculate and move upward if the last filled cell didn't equal the other columns

Please Login or Register  to view this content.

Yes Everything is OK now Thanks for explaining and for the support