VB Code to copy certain range from 1 sheet to another

[rizmomin]

Hello:

I have monthly sheet called Jan14,Feb14,Mar14......Dec14.

I need a VB code to copy
Cell Range H39: AB39 of Jan14 at H4 of Feb14
Cell Range H39: AB39 of Feb14 at H4 of Mar14
Cell Range H39: AB39 of Mar14 at H4 of Apr14 and so on until Dec14.

Please let me know if any questions.

Thanks

Riz

[Trebor76]

Hi Riz,

Though I'm not a fan of separate tabs for different months, try this where the the range is copied from Jan14 across the other months (which is what you're after I believe):

Please Login or Register  to view this content.

HTH

Robert

[rizmomin]

Hello Trevor:

I was under the impression that i had responded.
I am very sorry for my mistake and please, please pardon me.
I have tried your solution as file is attached but does not seem to work.
Please have a look and let me know and once again I am begging to forgive me for my not responding and I am sure it was my mistake and age of forgetting.
Thanks and looking forward to your response to forgive me.
Usually i have a habit of appreciating the completed solution and always leave nice feedback and close the thread.
Riz

[Trebor76]

I have tried your solution as file is attached but does not seem to work.

It does for me

What isn't working - when I look at the range H39 to L39 (even though your original post you said you wanted to copy H39 to AB39) from Jan14 has copied to Feb14 and Mar14?

[rizmomin]

Hi Trevor:

I have change the code to try for3 months first to see if it will work for me.
That's is what i have attached.
As you can see in the attached sheet, i wanted the copy data H39:*39 from Jan14 at Cell H4 of Feb14, Copy data H39:*39 at Cell H4 of Mar14 and so on.
Please have a look at my earlier attached sheet and let me know if any questions.
And once again i am very sorry if i have not explained it clearly.
Thanks
Riz

[rizmomin]

Hi Trevor:

I beleive i found the problem.
In your code you had data to be pasted at H39 instead of H4 as my original request.
Now it works great.
Thank you so much for your great expert help.
Riz

[Trebor76]

Thanks for the feedback and I'm glad we got it solved.