Hi
Ive got the formula of
=INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28))
which I believe takes the data from cells BA1-CT1 and also from BA2 to CT2 and works it way down the rows on a page. What Im trying to do is get the data starting from BA3 and copy all the way down the sheet as It is with other formula. The only thing is it will always be row 3 and just the one row.
Any Ideas?
Thanks
Ive got the formula of
=INDEX($BA$1:$CT$1,ROWS($A$6:A28))&" "&INDEX($BA$2:$CT$2,ROWS($A$6:A28))
which I believe takes the data from cells BA1-CT1 and also from BA2 to CT2 and works it way down the rows on a page. What Im trying to do is get the data starting from BA3 and copy all the way down the sheet as It is with other formula. The only thing is it will always be row 3 and just the one row.
Any Ideas?
Thanks