Hello,

I have a data set that contains formulas.
Due to the large size the formulas are only kept in the first row and
only copied down when report is updated monthly - these cells are then
hardcoded.

I cant copy formula down the whole way so need a loop to do copy
formula, calculate result and then hardcode before moving down to the
next row, each time taking the formula from row one.

Can anyone get me started on this?

thanks