Copy random range of cells to the same random format

[raamdrvr]

hi

I want to copy the cells by random range and paste it in the same random range

for example refer the insert image


Thank you

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[raamdrvr]

for example: if I select the cell A2, A4, A6 and A7 to copy and then have to paste the same in B2, B4, B6 and B7 as shown the table below.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Value[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4566[/TD]
[TD]4566[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]598[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]23[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]666[/TD]
[TD]666[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]789[/TD]
[TD]789[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Normal pasting places the values one under another, so I think this would have to be done via VBA, Im not an expert in that area.

 

[raamdrvr]

at a time I have to select these all cells A2, A4, A6 and A7 and paste it to another cell with same "row intervals"