Macro - Copy/Paste certain cells and move down column and repeat

**rohan87** · 01-15-2013, 12:57 AM

Hi,

I spent a while searching forums to get this working but I've hit a wall. I was wondering if someone here might have a better idea of using integers/loops/for/next statements than I do.

Basically what I want to do is this:

=======================

Sub test()

Range("u22").Select
Selection.Copy
Range("d236").PasteSpecial xlPasteValues

Range("d255").Select
Selection.Copy
Range("v22").PasteSpecial xlPasteValues

Range("d249").Select
Selection.Copy
Range("w22").PasteSpecial xlPasteValues

End

=======================

So Cells D236, D255 and D249 never change. I want to start with U22, paste it to D236, then copy the results from D255 to V22 and D239 to W22. Then I want these cells (U22, V22, W22) to move down +1 (so U23, V23, W23) are used.. this process will need to repeat 100 times.

I've tried programming a i = i +1 kind of thing but I just get hopelessly lost!

Any help would be magical.

Thanks.

Rohan

**rcm** · 01-15-2013, 01:29 AM

Let me see. You want D326,d255,and d249 to receive the contents of u22,v22,w22 and then up to the results of the rows below ending with u122,v122,w122? do you want to concatenate these results?

**rohan87** · 01-15-2013, 01:48 AM

I figured it may be easier to explain with a quick sketch - excel.jpg

Excuse my error of placing row 249 below row 255 in the image.

Let me know if you have any questions.

Thanks!