Loop through data on a workbook, selected it and paste in current workbook

Hi,

I have code which basically looks at column A, loops through the data and stops when there is no longer data. While it loops, it copies what is in column A into column B.

Please Login or Register  to view this content.

What I want to do is expand this idea to do the same thing but to loop through data in a different workbook on a particular sheet and as it loops through it copies the data into the current workbook and once again stops when there is no data. I'm a beginner to vba so I've put together some code which may kinda give an indication of what I want to do.

Please Login or Register  to view this content.

Thanks in advance

Hi,

Here are the path names. The Destination File will be open and I would like to run the macro from here

Source File : C:\Users\mjacob\Desktop\Source_File.xlsx

Destination File : C:\Users\mjacob\Desktop\Destination.xlsx

Thanks

jraj1106,

I'm really sorry for the late response. Your macro seems to work however there are multiple columns and I only require column A. Can you assist?

Thanks