calculate average in a particular column for every 100 degree increasein some other column

Dear Sir / Madam,

Please give me the VB macro coding for excel:
To calculate average in a particular column for every 100 values in some other column? pls give me the complete coding ....
Like there are two columns namely TT(TEMPEARATURE TIME) and WATER SUPPLY DEMAND.
when TT column increases for every 100 values (ie., 100, 200, 300, 400,.... so on), I need the average of WATERSD to be calculated at that 100th value.. please give me the complete coding.... as soon as possible, I need it very urgently...

More clearly... see in this whenever the TT value is reaching approx. to 100 then the average of water SD has to be calculated at that value… for example, TT approx. reaches 100 at 13th row, now at this row the average of waterSD has to be calculated… then again at 20th row when TT is Approx reaches next 100th value i.e., 200… now at this row the average of water SD has to be calculated… likewise for every 100 increase in TT column, the average of Water SD has to be calculated.( and not at 100th row as in the prev code)..
It would be highly helpful for me, if u can modify the code and give me.. pls do help me …
I HAVE ALSO ATTACHED THE EXACT EXCEL FILE FOR YOUR KIND REFERNCE AND PERUSAL...

1. TT WaterSD
2. 0 1
3. 0 1
4. 0 1
5. 13.194 1
6. 20.911 1
7. 32.551 1
8. 37.519 1
9. 40.601 1
10. 55.486 1
11. 69.986 1
12. 84.336 1
13. 99.662 1
14. 114.751 1
15. 129.835 1
16. 144.17 1
17. 159.148 1
18. 172.955 1
19. 187.301 1
20. 201.842 1
21. 217.044 1
22. 231.639 1
23. 246.388 1
24. 261.28 1
25. 275.669 1
26. 290.487 1
27. 303.537 1
28. 316.197 1
29. 328.542 1
30. 340.692 1
31. 352.792 1
32. 366.13 1
33. 380.516 1
34. 395.255 1
35. 408.905 1
36. 421.855 1
37. 433.705 1
38. 447.105 1
39. 459.905 1
40. 473.455 1
41. 487.996 1
42. 502.385 1
ALREADY TRIED CODE:

Please Login or Register  to view this content.

attach please a sample xls file with data and desired result

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Your title does not comply with rule 1. Please change it, then the users will be able to help you.

Click on Edit Post, Go advanced. You will see the edit title box - enter this "calculate average in a particular column for every 100 values in some other column". Click on save changes.