Faz Wrote:
Highlight and copy everything to be copied, select cell A3, paste,
select cell A551, paste, select cell A1099, paste, select cell A1647,
paste.
It should reach row 2194, not 2200.

Faz's reply is correct if you want your data in blocks. If you want
your data grouped by row as in my second scenario, use the following
format for your formulas on sheet2:

Place this in A3 on sheet2 =INDEX(Sheet1!$A$3:$A$550,INT(ROW()/4))
repeat the above formula for each column, changing the reference to
reflect the desired column, e.g.:
=INDEX(Sheet34!$B$3:$B$23,INT(ROW()/4))
and copy down 2200 rows

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=475866