Copying and pasting repeatly over 5000 rows (Macro).

[GregOgie]

HI to all,

I have recorded a macro to copy and paste two different location.

At each row # under column B to U and paste to V1 (in the range V1 to AO),
and wait for all values to change over 5000 rows of 20 columns across (V1 to AO1).
Then copy at location range D2:U2 and paste to column AR1 (in the range AR1 to BI1)
to over 5000 rows 18 columns across.

The recorded macro below, I want to this macro modified to automatically to run by
itself from beginning to the end of range (over 5000 rows).

I don't want to keep on copying and pasting each rows over 5000 rows.
Range("B1:U1") keep on changing until it reach over Range("B5000:U5000") end of
range.
Range ("AR1") keep on pasting until it reach over Range ("AR5000") end of range.

Please noted*** that Range("D2:U2") and Range("V1") are one single row only, these
don't changed and stay as they are in the macro.

Please Login or Register  to view this content.

Any help will be appreciated, thanks.

Greg

[mrice]

Suggest that you post a workbook with a before and after example to increase clarity.

[GregOgie]

To mrice,

Done and paste the attachment file and made the file smaller, don't want to sent large rows of data.

Greg

[Cutter]

@ GregOgie

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.