Identify last cell in another column and copy data to that row in another column

[bavarunbansal]

Hi Wonderful People,
I am a newbie in VBA and trying to automate my routine office work in excel. However I'm stuck at a place and not able to move forward and hence requesting your inputs.

Problem -
I've two columns A & B. Column B has some data. I need to find the last cell of column B and then copy paste the data from A1 till the last row of Column B.

I was able to make my way thru finding the last cell in column B, however I couldnt copy paste the data in cell A1 to the last row.

Please help.


Thank you
Varun

[davesexcel]

Please Login or Register  to view this content.

[MarvinP]

Hi Varun,

See if this code makes sense:

Please Login or Register  to view this content.

[sintek]

Do you want to copy A1:B and last row in B and paste it somewhere...
Not sure what you want to do with it once copied...

Please Login or Register  to view this content.

I need to find the last cell of column B and then copy paste the data from A1 till the last row of Column B

Or do you want to copy A1 to next available row in Column B

Please Login or Register  to view this content.

[bavarunbansal]

Hi Sintek,
thank you very much for your response. I am attaching a sample sheet of what i want to automate. I wasn't able to achieve the desired result with the code snippet you have shared.

Thank you
VarunScreenshot 2020-10-03 at 9.33.17 PM.png

[bavarunbansal]

Hi Marvin,
I am attaching a sample screenshot for your reference. I am not able to achieve the desired result from your code.
Attachment 698099

[MarvinP]

Hi Varun,

From your question I thought column A was longer than B.

To get a better answer you should supply a sample workbook instead of an image.

[sintek]

Copy This Text In A2??? to Last row in Col B?

Please Login or Register  to view this content.

[davesexcel]

OKay, I think the OP want to fill column A to The last row in column B

Please Login or Register  to view this content.

[MarvinP]

If you click on your cell and then double-click the bottom right corner of that cell it will do what you want without VBA. See:
https://www.bing.com/videos/search?q...01DC&FORM=VIRE

[davesexcel]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.