Need help with Macros and VB
Posted by Jeff on November 15, 2001 10:48 AM
I have a problem that shows each of 60 degrees (60 points) has a different number of data points collected
(i.e., 5 degrees may have 7 associated data points, 6 degrees may have 3,...).
I need a program (macro?) that will put all the data points for "6 degrees"
in a cell, average the cell, then move on to "7 degrees" and do the same...
This could be done manually. However, the typical data
file has about 2000 data points.
This would be easy if Excel would allow me to write a BASIC program.
Maybe this could be done in a Visual Basic module???