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

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