View Single Post
  #1   Report Post  
Old March 27th 19, 06:46 PM
shrek shrek is offline
Junior Member
First recorded activity by ExcelBanter: Aug 2005
Posts: 8
Default Help required on a formula.

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.