Hi All,

I wish to drag and copy a formula down in one column, but it needs to copy the data in the row to the right. e.g. in field z1 I need to copy a1+a3 when I drag down into aa1 it will copy a2+a4 when I need it to copy b1+ b3

I have tried to add the formula in the adjacent rows then drag across, then copy and paste using transpose, but the data is being returned as ref#

Is there a simple solution so I can drag down but copy data from the right?

Regards

Chris