Hello

I currently have data on B11, C11, D11 etc that I would like to copy to A2, A3, A4 etc, so now A2 is the same as B11, A3 is the same as C11 and so on.

I searched for a solution to this and I believe I need to use INDEX, but using other peoples examples, I can't quite get it to work for me. I'd simply like to drag down and have it copy different columns, but keeping the row reference the same.

Thank you