I need to do copy and paste in the following order:

1) I want to copy cells randomly leaving some cells in between. eg - select A1, C1:D1 ( Leaving out the cell B1) using CTL-G function and copy.

2) I need to paste in the same order of cell selected into ROW 2 - A2,C2:D2, without replacing the existing data in B2.

3) If i paste the randomly selected cells, it get pasted continuously from A2,B2,C2. So the existing data in B2 got overwritten.


I have a large amount of data to be copied in this order leaving in between cell in a row and paste in same order. Now i have to copy one cell and paste column by column.It takes lot of time.