Apologies if in wrong area.


I have the following formula of which links and paste data in column B. What im trying to do is do the same formula so it takes data from BA7 to CC2 and paste in column F

=INDEX($BA$1:$CC$1,ROWS($A$6:A6))&" "&INDEX($BA$2:$CC$2,ROWS($A$6:A6))

I tried changing to whats below but it not working.

=INDEX($BA$7:$CC$2,ROWS($A$6:A6))&" "&INDEX($BA$7:$CC$2,ROWS($A$6:A6))

Any ideas what ive done wrong.

Thanks