Copy & Paste Variable data length into summary sheet after last used row

I have a sheet named "VA05" where daily data is posted. This sheet contains Columns A:P and will be different lengths daily(row counts). This will require the entire range to be selected excluding the header row in Row1. The copied data will be pasted in sheet "VA05Cmbd" after the last row with data in column A:P. The paste will need to occur at the next row after the last row with data. The columns match between both sheets and both are in the same workbook.

See if this works for you.

Please Login or Register  to view this content.

Hello,
I tested the macro today and it does appear to work as designed.
I would only like values to be pasted into sh2 (VA05Cmbd) How can I adjust for values only?
Thanks

Change this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Solved Excellent work on the code Thank You