I want to automatically fill / clone / copy column E
(from cell E8
down to E100
) to L8
, S8
, Z8
etc.
Is this possible using a formula?
I want to automatically fill / clone / copy column Is this possible using a formula? 


If you're ok with dragging over all existing columns you can use this formula in F8 and drag across and down:



One way would be to put Potentially that is a lot of formulae and these may interfere with subsequent entries such as into Counting from 1, ColumnL happens to be 7 to the right of ColumnE but also Column 12 to Excel. So in ColumnL COLUMN() [ie 12] 5 is 7. MOD(…,7) will give a residual for any number not divisible by seven but not (ie =0) when that number is a multiple of seven. The 


You can clone the column by entering 

