How to create a summary report from several files???

Hello!

I've faced a problem concerning creating summary report from several files.

I've attached 5 files including the data of the particular weekday.

How to create one weekly review/report wich includes the data from all the 5 files?

Thanks in advance!

Save this file in the same folder as your five files

Open it

Stand back

NB: This will summarize all the files in that folder.

Please Login or Register  to view this content.

Thanks!

There are two additional questions:

How to change the macro code:

1) To set a range from column A to Z;

2) To include all the files from the particular folder (e.g. if I change the number of must be included files to 147 - difficult to count).