How to copy the cell which has formula

[sugavanam]

Hi,

How to copy the cell which has formula by using macro

* I need to copy the 1500 cells in one column and paste into multiple times [20]

Attached sheet for referance...

1.The sheet is opening with 16 column
2.If i give input as 20, further 4 columns to be added [ Not affecting the column 'U' ]

Please guide me to solve the same.

-Sugavanam