Averaging Weather Data

[JMD]

Hello All,

I was hoping anyone could help me with a large excel file I am analysing. I have weather data for a considerable amount of time taken at 15 minute intervals. I would like to average this data into hourly intervals. As a result, I would like help writing a macro that would insert a blank row after every fourth row. After that, I would like to have the averages of each column's 1-4 rows averaged. I've found some code online and changed it to insert a row every fifth row, but it only averages the data in column A. I would like it to average columns A through H. Below is the code:

Please Login or Register  to view this content.

TIA,
Josh

[rylo]

Josh

Firstly, can you please review the rules on wrapping code. I've edited your post to include the wrapping.

With your code try changing the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo