Copy cells from multiple worksheets and workbooks to one master workbook

Hi Guys,

Let me start by saying that I'm quite new to excel programming and hope this is the correct forum to put this in. What I have is twenty workbooks (Named 1-20.xls) and a master workbook(Master.xls). I am wanting to copy the data that's in the column "K" on four of the workbooks, worksheets (named 1,2,3,4) and paste that data into the "Comments" tab in the master workbook. Currently the macro copies only the column from one sheet and pastes into a new workbook.
The code(Found here is:

Please Login or Register  to view this content.

Is it possible to copy all the sheets, have the pasted data from each workbook in one column and paste it into the "Comments" sheet on the Master workbook?

Any help would be greatly appreciated.

Edit:

Have managed to make a macro that can do this, the code for anyone curious is:

Please Login or Register  to view this content.

Cheers~

Try this,
If you can put all your filess into one subfolder, this will go through each file in that folder and copy the ranges you want. Don't put anything else in that folder but the files you want data from. Also, don't put the master workbook in there either. Make sure you change the folders path in the code as well.

Please Login or Register  to view this content.

Hi JapanDave,

Thanks for your response! I am trying to run the code but getting the following error "Run-Time error'1004':"

"" could not be found. Check the spelling of the file name, and verify that the file location is correct." Clicking debug shows

Please Login or Register  to view this content.

to be the cause.

** I have found a solution to the problem and have posted the code I have used in the original post above. Thanks again for your assistance. **

Whoops, mistype

Please Login or Register  to view this content.