Average of 24 in 24 cells using macro VBA

[afdsmartins]

Hello,

I'm a newbie using Excel Macro, I have to do the average of 24 values that are in 24 cells (from B2 to B25) and repeat the process for cells B26 to B50 and so on. I have 8000 values and it is really hard to do this one by one. Can anyone give me some help?

Thank you in advance

 

[ismii]

In cell "C25" put

=AVERAGE(B1:B25)

Highlight C1:C25, then copy down to the end. What should happen is on every 25th cell the formula is for those 25 values.