Copy Data from "Source" Sheet to "Target" Sheet (Code need help thanks)

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thanks amended.

Is this how you want?

Please Login or Register  to view this content.

Originally Posted by jindon

Is this how you want?

Please Login or Register  to view this content.

This can merge but my case is that the header always different. Need the code to find then merge at same header.

Please Login or Register  to view this content.

Originally Posted by jindon

Please Login or Register  to view this content.

Hi, just tried. but it didn't copy to same header.

1) Don't quote whole post unless you really need to do it, the forum doesn't like it.

2) I did other way around...
try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Originally Posted by jindon

1) Don't quote whole post unless you really need to do it, the forum doesn't like it.

2) I did other way around...
try change

Hi, it works now! Thanks.

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Originally Posted by jindon

You are welcome.

Hi if i want to check form a1 till the end, seem like this code till k1 only.

Please Login or Register  to view this content.

You can change it to

Please Login or Register  to view this content.

Originally Posted by jindon

You can change it to

Thank you, wish you have a good day!

Try change to

Please Login or Register  to view this content.

Originally Posted by jindon

Try change to

Thank you!!

Originally Posted by jindon

Try change to

Just now using code for one of my excel, i encounter this error. Not sure how to fix this.
1.jpg

No idea.
Upload your workbook.

Originally Posted by jindon

Upload your workbook.

workbook is attached. Thanks
Attachment 632873

I think i found the problem, if i uncheck the R1C1 reference style, the code works fine



1.jpg