help with copy and paste

[covi2k2]

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

[swatsp0p]

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.

[Faz]

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.

[swatsp0p]

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