Need help vb marco copy a range of data to a template

[venkatpvc]

Hello Every Body,

I am new to this forum and from last 10 days I am reading posts in this forum, there is lot to learn in this forum. Thank you everybody who are contributed here.

Thank you for each and every Excel Super Stars here.


I am new for VB Excel Marcos; I am in basic stage of Excel VB Marcos.

I need help from you guys. I already created a Marco for my problem. But it’s too big. Anybody here can help how can I do it in short way.

I have bunch File Names In Sheet2 column A

When I Clikc button Copy paste its need to copy paste the data from Sheet2 column A to Sheet1 Template.


I just want is there any other ways doing this……

Here is my code:

Please Login or Register  to view this content.

[mehmetcik]

Hi

Why are you creating all those ranges?

is this to copy the data across or do you actually need them ?

Please Login or Register  to view this content.

[venkatpvc]

Like I said before, I am new to VB Marcos

I am learning that's why I posted this question is there any better way to do this?

Thank you,

[mehmetcik]

replace your copy paste lines with the following:-

Please Login or Register  to view this content.

[venkatpvc]

Thank You, mehmetcik.

You Showed me easy way I will change my entire Code. Any more suggestions on this. or I can close my thread with solved.

[mehmetcik]

Yes.

If your pages were side by side then a simple loop three or four lines would replace all your copy paste routines.

I will create one for you. Just to demonstrate.

If you insist on the sheets being arrange vertically then you will need two nested loops. bit more complicated.

[venkatpvc]

Can you give me a demonstrate sir? Thats really help for my learning process.

Thank you,

[mehmetcik]

This replaces call your copy paste code.

Please Login or Register  to view this content.

[mehmetcik]

Additionally

You do not need to modify it as your data grows.

However you will need to format the pages.

But that is another issue.

Copy Paste special Formats for a whole page in a loop like the one above is all you need.

but remember to make all the columns the same width.

[venkatpvc]

Thank You so much for you help!!!