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.

	A	B
1	Value	Result
2	4566	4566
3	598
4	23	23
5	2
6	666	666
7	789	789

<tbody>
</tbody>

 

[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"