help with copy and paste

C

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
 
B

Bernie Deitrick

Either:
Copy the range A1 :J550, then select A1 on sheet2 and Paste (ctrl-V), press
end down-arrow, down-arrow, Paste (ctrl-V), press end down-arrow,
down-arrow, Paste (ctrl-V), press end down-arrow, down-arrow, Paste
(ctrl-V), and you're done.

OR

Copy the range A1 :J550, then select A1:J2200 on sheet2 and Paste (ctrl-V),
and then you're done.

HTH,
Bernie
MS Excel MVP
 
Top