Pasting data into every second row, and also pasting it as a duplicate

[rhibrown]

Hi there,

I need to copy the data in Column G of 'workings', and then paste it into 'template' at L39, but need each line to duplicate.
So it will show:
ICT.1516.001
ICT.1516.001
ICT.1516.003
ICT.1516.003
ICT.1516.004
ICT.1516.004 etc - I'll need to do this for another 1 or 2 columns also (column T to J as per above)


I also need to copy Column E from 'workings' and paste it into 'template' at D39, but have it paste into every second row:
55

55

55

54

30
I also need to do this with more columns

Any help would be greatly appreciated!!

 

[vletm]

rhibrown
Why You didn't continue in Your previous case ... ?

Copy data and paste it into every second row

I would like to be able to copy my data from Column T, and then paste it into another column, but into every second row. So if I had these values in column T: 2 4 5 6 7 I would like to copy and paste it into another column to show: 2 4 5 6 7 I'd also like another part of the code to copy...

chandoo.org

Now, You have file, but ...