I hope someone can help me with this? I need to know if there is a way when copying a formula it will copy horizontal instead of verticle (cell wise). I hope this makes sense?

I have a formula =T('Detail Results'!B20) and when copied it changes to B21 and I would like it to change to C20, D20, E20...etc. Otherwise, I have to manually change the cell and I have over 1000 to do.

Any ideas?

Thanks,
Paul