Macro for copy multiple workbook fields copy to one workbook

[huson]

I am not familiar with the Macro. All I know is only a little of recording the macro then modify some value to use.

Now I am facing a problem and just thinking if anyone can help with this. Thanks in advance anyway.

I have some excel workbooks that basically have the same worksheet layout and values in the same columns of one worksheet but with different number of rows. These workbooks are saved to one folder only. I have a list of these excel files in one worksheet. All I want is that to copy these rows of data in one excel file worksheet for further analysis, or may linked this worksheet to access for analysis. This action is required to do every month so that I hope to have a macro to save effort.

Can anyone help?

 

[Tinbendr]

Ron has written extensively on the topic. See if this page can help. Post back if you have more questions.

 

[huson]

Thanks for your example. However, in my case, I have to copy the standard worksheet from several (around 50) excel files. How does the copy from files work? Can I copy the files according to the file list in one worksheet?

 

[Tinbendr]

Did you look around on his site.

Here's a link to the 'Copy all files in a folder.