Need some suggestions

[Guest]

I have two spreadsheets. I need to average some data and pass that
information to the other spreadsheets through code.

The information I need is average by Month by Hour. The first spreadsheet
has rows of days and months (1-Jan , 2-Jan , etc…) for a whole year and
columns of 15 minutes times (7:00,7:15:7:30,7:45, etc…).

So I need to get data by Month by Hour (Jan 7:00 = ). I was trying to think
of a loop that would cycle through the first spreadsheet and populate the
second but I haven’t really ever program in excel before. Any help would be
GREAT!

 

[Guest]

Do you need it to run by Macro or would a the avg. function work?

 

[Guest]

Macro

Do you need it to run by Macro or would a the avg. function work?

 

[Guest]

Here's the a basic macro that averages you'll have to modify it a little hope
that helps.


avg = Application.Average(Range("Sheet1!D17"))
Worksheets("Sheet2").Range("A8") = avg