Hi Harlan,

I maded the modifications to this:

Col_A =T(INDIRECT("'"&INDEX(WSLST,1+INT(S/N))&"'!A"&(2+MOD(S,N))))
Col_B =T(INDIRECT("'"&INDEX(WSLST,1+INT(S/N))&"'!B"&(2+MOD(S,N))))
N =8
S =ROW(INDIRECT("1:"&(N*ROWS(WSLST))))-1
WSLST =Sheet1!$A$2:$A$3


Now it gining me a #NUM! error.

Are the above name ranges are correct?






Harlan Grove wrote:
Fin Fang Foom wrote...
...
Here how I set it up.

Col_A =T(INDIRECT(""&INDEX(WSLST,1+INT(S/N))&"'!A"&(2+MOD(S,N))))
Col_B =T(INDIRECT(""&INDEX(WSLST,1+INT(S/N))&"'!B"&(2+MOD(S,N))))
...

These are problems. The first literal strings should be " ' " (without
the spaces around the single quote/apostrophe) rather than " ". This is
a purely protective measure. If your worksheet names don't contain
spaces or hyphens, you don't need to put single quotes around them, but
it doesn't hurt when they're not needed, and it prevents errors when
they are needed.