Copy all column data from one sheet in a woorkbook & paste onto last row of another column in a different sheet of a different workbook

[MUJEEBOB]

I've been struggling to get this for about a week now. Part of my job is compiling time and value data from one workbook (wb.BMBG, sheet.CAD, A6 to end of column and row E) and pasting it into the last rows of two different columns in another workbook (wb.RTRs, sheet.cad, end of data in column A and end of data in column B)
I can sort out the rest of the code given that in code, i can:
1) access the specific sheet in the specific workbook
2) consistently select and copy from A6 (or any other row)
3) paste after the last filled cell in the destination file.
Any help would be highly appreciated

 

[MUJEEBOB]

You're a life saver. I was looking at it in such a complicated manner myself. Thank you! Also, if you have any good references for how i can learn more about creating logic loops, please do share!

 

[Joe4]

You are welcome.

The code I posted does not use any logic loops, so I am not sure if you are now asking a totally different question.
But if you do a Google Search on "Excel VBA Loop Types", you will find many good resources, like this one:

VBA Loop

Loops in VBA allow users to repeat the same code block multiple times until a specific point is attained or a given condition is met.

corporatefinanceinstitute.com

 

[MUJEEBOB]

You are welcome.

The code I posted does not use any logic loops, so I am not sure if you are now asking a totally different question.
But if you do a Google Search on "Excel VBA Loop Types", you will find many good resources, like this one:

VBA Loop

Loops in VBA allow users to repeat the same code block multiple times until a specific point is attained or a given condition is met.

corporatefinanceinstitute.com

yeah i just have this other upcoming assignment (which is a bit more complicated than this) and i was hoping to educate myself so i can make it easier for myself when i sit down to automate it.
Thanks.