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

New Member
Joined
Aug 10, 2021
Messages
8
Office Version
  1. 2016
Platform
  1. Windows
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

New Member
Joined
Aug 10, 2021
Messages
8
Office Version
  1. 2016
Platform
  1. Windows
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! :)
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
59,499
Office Version
  1. 365
Platform
  1. Windows
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:
 

MUJEEBOB

New Member
Joined
Aug 10, 2021
Messages
8
Office Version
  1. 2016
Platform
  1. Windows
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:
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.
 

Forum statistics

Threads
1,144,342
Messages
5,723,813
Members
422,518
Latest member
quack_quack

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top