I am now getting the error message, " you have entered too many arguements
forthis function"

"Bryan Hessey" wrote:
[color=blue]

To start in F5 set the initial to that, in AA5 copy / paste the formula

=IF(OFFSET($F$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16)=0,"",OFFSET($F$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16))

and in AB5 copy / paste

=IF(OFFSET($G$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16)=0,"",OFFSET($G$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16))

and formula-drag downwards



apples72 Wrote:
I am getting an error in the formula... does it matter that I am
actually
starting in cell F5 and G5.

That way, cell AA5=F5, AA6=H5
and AB5=G5, AB6=I5, etc....


"Bryan Hessey" wrote:



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=484621