Copy rows from diferents books using macros

[maorza]

Hello friends: I would like your help in the following. I have a directory with several books and each book has a different number of worksheets. Manually created a book called Maestro with a single worksheet and wanted to create a macro that opens the diferents books in directory and open eachone of the worksheets of these books by copying all the rows with data. The copy should start in row 5 of the worksheets and continue as long as there is data. Control whether data is in column A. For example if a100 (a500 or A800 can be) no data, skip to the next sheet or book. All sheets have the same structure. In the end, Maestro would have all the rows of books that are in that directory. I hope letting me explain and appreciate your time and patience. my english isnt'n good. Regards

[JBeaucaire]

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.


===============
Based on the code on that page including the option shown below it for cycling through multiple sheets, something like this:

Please Login or Register  to view this content.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.