CopyRange to a Column one below another

[bgonen]

CopyDynamicRange.png
Trying to copy range F1 to last active row (in this example it is F1:F3 but this range always changes);

Copy the range to Column E but start from E6 (based on where the text "ACTUAL" endsCopyDynamicRange.png)

So in this case I need range : F1:F3 copied to E6:EE8, then copied again to E9:E11 then copy again to E12:E14),

Basically copy the ranges one below the other until last active cell of column D

[AlphaFrog]

Please Login or Register  to view this content.

[bgonen]

Hallelujah !!!

I tested it and it works perfectly. Thank you so much.
All I need is to combine this code with my larger code.


Happy Holidays

[AlphaFrog]

You're welcome. Thanks for the feedback.

[bgonen]

I think I got stuck;
Suppose the same range (F1:F3) is not on the same active sheet let's say if the range is on sheet2


What do I need to do to modify the code?

[AlphaFrog]

I think I got stuck;
Suppose the same range (F1:F3) is not on the same active sheet let's say if the range is on sheet2


What do I need to do to modify the code?

Please Login or Register  to view this content.

[bgonen]

You are a life savior, thanks a lot.

One last question, suppose I want to pick slightly different range like F6 thru J all the way down to last active row of J

What exactly I need to change

[AlphaFrog]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[bgonen]

Slick, it works like a charm.

Thanks again for the quick help.