Copy Data And Paste it at the bottom of the latest field

[nonono]

I am trying to copy this data and paste them into another worksheet and making sure it is at the bottom of the latest data in the worksheet How do i go around doing that?

I am trying to copy the whole data from A1-K14. (Data is dynamic so it might contain more/less everytime a new report is generated)
Once I copy it, I would like to have the data at the bottom of the row in OEE_Original

I would like to have the data A1-K14 to the new cell A178. I wish to retain the formatting which is important and the value as well.

Hope a god can rescue me since this is the final step....

 

[My Aswer Is This]

Try this:
Run this script from the copy from sheet:

Sub Copy_My_Data()
'Modified 8/2/2018 12:55 AM  EDT
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "H").End(xlUp).Row
Dim Lastrowa As Long
Lastrowa = Sheets("OEE_Original").Cells(Rows.Count, "H").End(xlUp).Row + 2
Range("A1:K" & Lastrow).Copy Sheets("OEE_Original").Cells(Lastrowa, 1)
Application.ScreenUpdating = True
End Sub

 

[nonono]

wow sir.... are you god. you are so good at the vba coding ><

Thank you for helping me twice
appreciate your time and effort T.T

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

wow sir.... are you god. you are so good at the vba coding ><

Thank you for helping me twice
appreciate your time and effort T.T