Hi Everyone,

Hope this is the right place for this question but here goes: -

I have a file where I want to copy data from one cell to a whole row the data needs to increase by the number and nothing else the words stay the same, it is set out like this: -

The Data in Column B1 =Data!Y2

The Data in Column C2 - AV48 needs to look like =Data!Y3, =Data!Y4, etc right up to =Data!Y48

The only way I can do it is to do every column one at a time don't know if there is a simpler way of doing it or not.

Kind Regards,

Mark