Flip copy paste values using Macro, first row already fill with the data egg copy from row B to C

[bocah]

Hi Guys,

Can you solve my problem.

I try to copy pastevalues using macro, but instead of copied to the right I want to copy it to the left. because the data in the right already fill with certain data.
I already attach the example.

Thanks before

Note: "sumber" is the data source, and "target" is the target paste.

 

[Joe4]

Welcome to the Board!

I cannot say I really understand what you are trying to do (and judging from the lack of responses, I expect others may be in the same situation).
How exactly are you deciding where to place your data?

Perhaps it would be better if you walked us through the example step-by-step, explaining where you are placing each piece of data and why.
Be very specific, telling us exactly which cell is being copied where and why.

Also, are the source and target sheets in the same workbook, or different ones?

 

[bocah]

Different Workbook

 

[Joe4]

You only answered one of my questions. You neglected to address this:

Perhaps it would be better if you walked us through the example step-by-step, explaining where you are placing each piece of data and why.
Be very specific, telling us exactly which cell is being copied where and why.

If you want assistance, please provide more detail. Remember, while you are very familiar with your set-up and what you want to accomplish, we are not.
All that we know is what you decide to share with us.

Also, is your code to assume that both workbooks are already open or is your code supposed to open the other workbook?
If it is to open the other workbook, are you hard-coding the file path and name, or do you want to prompt the user to browse/select the file?

And which workbook is the VBA code to be located in?

Please be sure to address ALL these questions in your reply.