Copy and paste selected cells only

[PJFry]

Hi. I want to copy certain cells from a row and paste them in the corresponding row numbers, but in another column.
For example, I want to copy cells A1, A7, A28, A2000 and paste them in D1, D7, D28, D2000.
When I select cells A1, A7, A28, A2000 and paste them at D1, cells paste adjacently, together.
Is there way to do it in a way? Please, consider that cell references are given for example, it may involve lots of cells and distance between the cells in the same row can be big.
Thanks.

 

[Joe4]

Welcome to the Board!

Here is a little macro that you can run that will copy any cells that you have selected to column D of the same rows.
So, just select the cells you want to copy and run the code:

Sub MyCopy()

    Dim cell As Range
    
    For Each cell In Selection
         Cells(cell.Row, "D") = cell
    Next cell
    
End Sub

 

[cerfani]

You can write a macro to do it but if you will not always paste the same rows of the column, you need to first identify which cells you will copy.

Example to copy from A1 and paste in D1:

Sub CopyPaste()
    Range("A1").Copy Range("D1")
End Sub

You can use loops for multiple copying and pasting and a variable to hold the row numbers. You didn't give enough info to describe what the code would be so you must determine the logic of selecting rows.

 

[Joe4]

you must determine the logic of selecting rows.

Not necessarily. It can be dynamic, based on whatever they have selected (see my reply above).
That will handle ALL of the cells that they have selected.

 

[PJFry]

Thank you, it works!
Is there also a way or trick to do this via the buttons/excel interface without macros?

 

[cerfani]

Not necessarily. It can be dynamic, based on whatever they have selected (see my reply above).
That will handle ALL of the cells that they have selected.

Yeah I overlooked the title of the thread. In his post he described the cells would be different distances from each other so I assumed he wanted the macro to select the cells but after I posted I saw he had said selected cells.

 

[Joe4]

Is there also a way or trick to do this via the buttons/excel interface without macros?

Buttons run VBA code (macros), you just don't see it.
You can easily put a Command Button on your form and link the VBA code to it.
See the "Assign a button (Form control)" section here: https://support.office.com/en-us/ar...l-button-d58edd7d-cb04-4964-bead-9c72c843a283