Create a summary of different Excel files to one file.

[NewBee_HS]

Dear Excel-specialists,

I have a question regarding the following.
Currently I have a folder with a lot of Excel-source files that contain different information.
The source-format (framework if you will) is the same as the destination format.

What I like to achieve is:
1. Use a (VBA script) loop to go through each Excel file in a specific folder.
2. For each file, extract all data from sheet "Example" starting from row 9.
3. Copy the data as plain text, without any markup or formatting.
4. Append all data into a summary file, without overwriting existing data in the source file (append).

Result: The summary file contains all the data from each source file, combined into one place.
Is it easy to create (in simple code, so I can maintain it easily)?

I added 3 files to give an impression.
1. Destination_File (the summary file)
2. File_A_Example_Source_File and File_A_Example_Source_File (two source files with some example text).

I tried something with counters, but that does not work, so I really do not know where to start with this one.

Thank you in advance.

Hans

[NewBee_HS]

I found something, but this doesn't exactly do what I need... :-(
I tried to build a macro, but this does not work either.
https://chandoo.org/forum/threads/vb...m-where.45667/

[NewBee_HS]

Tried this code also, but it doesn't seem to work.

Please Login or Register  to view this content.

[MikeVol]

Hello. If you had headings for each column, you could use these headings to guide you for copying and pasting.There are enough such topics on this forum. But in the form you have, it’s unlikely that you’ll be able to do anything (at least for me). Since you have tables with data scattered throughout the sheet.