How to copy data to last row of another worksheet

Hi,

I have two worksheets, worksheet1 = "SalesOrder",
worksheet2 = "Allocation".

Both Worksheets have column headers from A- AC.

I need to copy those data from SalesOrder to add in the list of Allocation at the last row of worksheet 2.

I tried recorded macro with relative reference but it says
"The Information cannot be pasted because the copy area and the paste area are not the same size and shape."



Code for Record Macro

Please Login or Register  to view this content.

Code Which I tried to Write

Please Login or Register  to view this content.

The following statement will copy SalesOrder cells to ShipmentAllocation3 sheet at the end of the worksheet:

Please Login or Register  to view this content.

HTH

Jason

Thanks Jason, the code runs well