how to copy data from wrk1 to wrk 2-Please advise and comment, thanks so much!

mypic.jpg
I have encounter a problem to copy data from wrk1 to wrk 2.
This problem has not been solved out yet. Please help to make your comments and suggestion.

Thanks in advance!!

Heres my hack and slash attempt

im sure someone can have an more elegant way of determining last row

Thank in advance!

With file and jpeg provided, actually, this one gets more easy understanding than the others.

It shouldnt be like what you say. Unique presentation with file uploaded to demonstrate my case.

Well done! Many thanks to humdingaling ! In a step further, Can we copy the data from workbook1(sheet) to workbook2(sheet), not like from sheet 1 to sheet 2. Please help

yes....have your other workbook open

use Windows("filename.xlsx").Activate to switch between the two workbooks
if there are multiple sheets on the workbook you need to ensure the Sheet is selected also
example below

Please Login or Register  to view this content.

Thanks for your valuable comment.

Not a problem

If your question is resolved, mark thread SOLVED using the thread tools

Thanks