Hello,

I have multiple Excel files with 30-minute solar radiation data for 30 cities from 2005 to 2012 (240 files, to be precise). Each file's name format is "xxxxxx-2005", "xxxxxx-2006", and so on.

Within each file, there's solar radiation data for every 30 minutes for the whole year, that makes up 17,520 rows per file, like this:

Year Month Day Hour Minute Radiation
2007 1 1 0 0 375
2007 1 1 0 30 400
2007 1 1 1 0 425
2007 1 1 1 30 400
2007 1 1 2 0 400


What I need to do is create a macro that automatically adds every set of 30-minute data and displays it on a second sheet, so that there are not 17,520 rows but 365, and it would need to use the file's name to make it work on every file.

Any advice?

Thanks a lot in advance,

Bertram [: