I don't know much about VBA and do this by try and error. Cant figure out how to write a code to:
- Open all excel files in the folder
- Copy and combine one by one all data from a worksheet with a specific name to another separate excel workbook
Asked
Active
Viewed 46 times
0
Vova Khachaturov
- 3
- 2
-
Please edit your question with your code attempt, SO is not a code writing service. Also, there's a [similar question](https://stackoverflow.com/questions/68653018/how-do-i-have-a-macro-loop-through-a-folder-and-copy-data-from-one-excel-workboo) asked yesterday which I think you can take a look at. – Raymond Wu Aug 05 '21 at 09:39