i have 6 columns of data, A3:A550, B3:B550, C3:C550, D3:D550,E3:E550 AND
J3:J550, they are in a sheet called GRAD (2), I want o copy and past
these data in to sheet2 . but i want the data in each row to be copied
4 times so i will have 6 colums of data 2200 rows down.

hope some one can help


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

Do you want your data to be successive by block or by cell, i.e.

A3
A4
A5
A6...
A3
A4
A5...

--OR--

A3
A3
A3
A3
A4
A4
A4
A4...?

More info, please.


--
swatsp0p


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

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
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=475866

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