Thread
:
i need help
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
i need help
you could use a copy/paste macro 4 times.something like this
for i=1 to 4
x=cells(rows.count,"a").end(xlup).row+1
range("a3:e5550,j3:j550)").copy range("a"&x)
next
--
Don Guillett
SalesAid Software
"covi2k2" wrote in
message ...
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=475839
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]