copy till last used row of a column and paste it into another column of another sheet

[yogi_himalayan]

Every week I get data with random number of rows and I need to rearrange those data in certain order so it can accommodate with our system.

I have attached spreadsheet and would appreciate your assistance with macro to address following issue

1. need to find last used row and copy column I on sheet("internal") and paste to A2 in sheet("Int-SendOut")
2. need to find last used row and copy column H on sheet ("Internal") and paste to B2 in sheet("Int-SendOut")
3. need to find last used row and copy column C on sheet("Internal") and paste to C2 in sheet(Int-Sendout")

I am wondering what would be vba code to achieve the result based on last used row.

Thank you very much in advance for your assistance.

[Trebor76]

Hi there,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[yogi_himalayan]

Hi Robert,

Thanks. I use the above code but it is only returning value on row 2 of sheets("Int-SendOut"). Is there any way we can get all data till last used row from sheets("Internal") and have them pasted on sheets("Int-SendOut")

Kind regards

[Trebor76]

Oh, OK. Try this:

Please Login or Register  to view this content.

Regards,

Robert

[mangesh.mehendale]

hii

Try this ...

Please Login or Register  to view this content.

[mangesh.mehendale]

Hii Trebor76,
What is this coding nice ...

Let me know about

Please Login or Register  to view this content.

[yogi_himalayan]

Thank you Robert. Such a nice and perfect code I would have never learnt on my own. I was never aware that we can use copy paste array as you have used. Much appreciated your time and effort.

Kind regards

[yogi_himalayan]

Thank you Mangesh for your time and effort. I have used Robert's code as it is short and sweet.

[Trebor76]

Hi Trebor76,
What is this coding nice ...

Let me know about
varMyCols In Array("I-A", "H-B", "C-C")

These are the columns the data is being copied from and to. For instance, column I to column A fro the first block. The varMyCols variable picks up each set of columns which are then split by the minus symbol "-" in the strMyCols array.

HTH

Robert

[Trebor76]

Thank you Robert. Such a nice and perfect code I would have never learnt on my own. I was never aware that we can use copy paste array as you have used. Much appreciated your time and effort.

You're welcome. Always extra happy to help a fellow Aussie

[mangesh.mehendale]

Quit hard because I am beginner .... Thanks...