Hi,
I have recorded a macro that is performing a couple of simple calculations on a dataset that is 12 columns wide by 8 rows tall. However, I now need to to have the macro loop those same calculations over each 12x8 block, until a blank row is reached. The data is very regular, every set is the same size and the next set occurs directly after. If desired Id be happy to upload the code I have. Here is an example of the data:
[TABLE="width: 930"]
<colgroup><col span="12"><col><col></colgroup><tbody>[TR]
[TD]0.000[/TD]
[TD]0.268[/TD]
[TD]0.260[/TD]
[TD]0.385[/TD]
[TD]0.205[/TD]
[TD]0.438[/TD]
[TD]-0.001[/TD]
[TD]0.381[/TD]
[TD]0.222[/TD]
[TD]0.732[/TD]
[TD]0.495[/TD]
[TD]-0.002[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-0.001[/TD]
[TD]0.327[/TD]
[TD]0.357[/TD]
[TD]0.334[/TD]
[TD]0.748[/TD]
[TD]0.243[/TD]
[TD]-0.002[/TD]
[TD]0.351[/TD]
[TD]0.288[/TD]
[TD]0.389[/TD]
[TD]0.028[/TD]
[TD]0.271[/TD]
[TD]High Growth[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]0.783[/TD]
[TD]0.000[/TD]
[TD]0.767[/TD]
[TD]0.000[/TD]
[TD]0.227[/TD]
[TD]0.368[/TD]
[TD]0.381[/TD]
[TD]0.765[/TD]
[TD]0.153[/TD]
[TD]0.425[/TD]
[TD]0.423[/TD]
[TD]0.306[/TD]
[TD]Med Growth[/TD]
[TD]51[/TD]
[/TR]
[TR]
[TD]0.303[/TD]
[TD]0.237[/TD]
[TD]0.350[/TD]
[TD]0.000[/TD]
[TD]0.466[/TD]
[TD]0.498[/TD]
[TD]0.099[/TD]
[TD]0.320[/TD]
[TD]0.001[/TD]
[TD]0.774[/TD]
[TD]0.780[/TD]
[TD]0.307[/TD]
[TD]Low Growth[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]0.065[/TD]
[TD]0.738[/TD]
[TD]0.340[/TD]
[TD]-0.001[/TD]
[TD]0.154[/TD]
[TD]0.352[/TD]
[TD]0.779[/TD]
[TD]0.720[/TD]
[TD]0.449[/TD]
[TD]0.746[/TD]
[TD]-0.002[/TD]
[TD]0.023[/TD]
[TD]No Growth[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]-0.002[/TD]
[TD]0.191[/TD]
[TD]0.346[/TD]
[TD]0.087[/TD]
[TD]0.787[/TD]
[TD]0.257[/TD]
[TD]0.317[/TD]
[TD]0.001[/TD]
[TD]-0.001[/TD]
[TD]0.318[/TD]
[TD]0.691[/TD]
[TD]0.232[/TD]
[TD]Sum[/TD]
[TD]96[/TD]
[/TR]
[TR]
[TD]0.687[/TD]
[TD]-0.002[/TD]
[TD]0.544[/TD]
[TD]0.052[/TD]
[TD]0.344[/TD]
[TD]0.752[/TD]
[TD]0.113[/TD]
[TD]0.691[/TD]
[TD]0.470[/TD]
[TD]-0.002[/TD]
[TD]0.481[/TD]
[TD]-0.002[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.000[/TD]
[TD]0.340[/TD]
[TD]0.252[/TD]
[TD]0.411[/TD]
[TD]0.293[/TD]
[TD]0.238[/TD]
[TD]0.371[/TD]
[TD]0.267[/TD]
[TD]0.712[/TD]
[TD]0.705[/TD]
[TD]-0.002[/TD]
[TD]0.003
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.001[/TD]
[TD]0.321[/TD]
[TD]0.274[/TD]
[TD]0.424[/TD]
[TD]0.250[/TD]
[TD]1.489[/TD]
[TD]0.600[/TD]
[TD]0.801[/TD]
[TD]0.296[/TD]
[TD]0.056[/TD]
[TD]0.008[/TD]
[TD]0.000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.318[/TD]
[TD]0.180[/TD]
[TD]0.087[/TD]
[TD]0.306[/TD]
[TD]0.010[/TD]
[TD]0.329[/TD]
[TD]0.323[/TD]
[TD]0.288[/TD]
[TD]0.335[/TD]
[TD]0.263[/TD]
[TD]0.011[/TD]
[TD]0.217[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.241[/TD]
[TD]0.154[/TD]
[TD]0.322[/TD]
[TD]0.183[/TD]
[TD]0.733[/TD]
[TD]0.001[/TD]
[TD]0.321[/TD]
[TD]0.726[/TD]
[TD]0.213[/TD]
[TD]0.308[/TD]
[TD]0.005[/TD]
[TD]0.299[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.744[/TD]
[TD]0.263[/TD]
[TD]0.344[/TD]
[TD]0.482[/TD]
[TD]0.514[/TD]
[TD]0.276[/TD]
[TD]0.286[/TD]
[TD]0.278[/TD]
[TD]0.229[/TD]
[TD]0.370[/TD]
[TD]0.389[/TD]
[TD]0.780[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.001[/TD]
[TD]0.390[/TD]
[TD]0.245[/TD]
[TD]0.186[/TD]
[TD]0.070[/TD]
[TD]0.010[/TD]
[TD]0.298[/TD]
[TD]0.271[/TD]
[TD]0.291[/TD]
[TD]0.352[/TD]
[TD]0.000[/TD]
[TD]0.646[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.222[/TD]
[TD]0.144[/TD]
[TD]0.335[/TD]
[TD]0.000[/TD]
[TD]0.348[/TD]
[TD]0.248[/TD]
[TD]0.708[/TD]
[TD]0.450[/TD]
[TD]0.344[/TD]
[TD]0.301[/TD]
[TD]0.096[/TD]
[TD]0.007[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.281[/TD]
[TD]0.331[/TD]
[TD]0.348[/TD]
[TD]0.687[/TD]
[TD]0.330[/TD]
[TD]0.301[/TD]
[TD]0.079[/TD]
[TD]0.381[/TD]
[TD]0.430[/TD]
[TD]0.308[/TD]
[TD]0.185[/TD]
[TD]0.007[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.000[/TD]
[TD]0.592[/TD]
[TD]0.677[/TD]
[TD]0.322[/TD]
[TD]0.288[/TD]
[TD]0.113[/TD]
[TD]0.357[/TD]
[TD]0.263[/TD]
[TD]0.239[/TD]
[TD]0.198[/TD]
[TD]0.736[/TD]
[TD]-0.001[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have recorded a macro that is performing a couple of simple calculations on a dataset that is 12 columns wide by 8 rows tall. However, I now need to to have the macro loop those same calculations over each 12x8 block, until a blank row is reached. The data is very regular, every set is the same size and the next set occurs directly after. If desired Id be happy to upload the code I have. Here is an example of the data:
[TABLE="width: 930"]
<colgroup><col span="12"><col><col></colgroup><tbody>[TR]
[TD]0.000[/TD]
[TD]0.268[/TD]
[TD]0.260[/TD]
[TD]0.385[/TD]
[TD]0.205[/TD]
[TD]0.438[/TD]
[TD]-0.001[/TD]
[TD]0.381[/TD]
[TD]0.222[/TD]
[TD]0.732[/TD]
[TD]0.495[/TD]
[TD]-0.002[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-0.001[/TD]
[TD]0.327[/TD]
[TD]0.357[/TD]
[TD]0.334[/TD]
[TD]0.748[/TD]
[TD]0.243[/TD]
[TD]-0.002[/TD]
[TD]0.351[/TD]
[TD]0.288[/TD]
[TD]0.389[/TD]
[TD]0.028[/TD]
[TD]0.271[/TD]
[TD]High Growth[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]0.783[/TD]
[TD]0.000[/TD]
[TD]0.767[/TD]
[TD]0.000[/TD]
[TD]0.227[/TD]
[TD]0.368[/TD]
[TD]0.381[/TD]
[TD]0.765[/TD]
[TD]0.153[/TD]
[TD]0.425[/TD]
[TD]0.423[/TD]
[TD]0.306[/TD]
[TD]Med Growth[/TD]
[TD]51[/TD]
[/TR]
[TR]
[TD]0.303[/TD]
[TD]0.237[/TD]
[TD]0.350[/TD]
[TD]0.000[/TD]
[TD]0.466[/TD]
[TD]0.498[/TD]
[TD]0.099[/TD]
[TD]0.320[/TD]
[TD]0.001[/TD]
[TD]0.774[/TD]
[TD]0.780[/TD]
[TD]0.307[/TD]
[TD]Low Growth[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]0.065[/TD]
[TD]0.738[/TD]
[TD]0.340[/TD]
[TD]-0.001[/TD]
[TD]0.154[/TD]
[TD]0.352[/TD]
[TD]0.779[/TD]
[TD]0.720[/TD]
[TD]0.449[/TD]
[TD]0.746[/TD]
[TD]-0.002[/TD]
[TD]0.023[/TD]
[TD]No Growth[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]-0.002[/TD]
[TD]0.191[/TD]
[TD]0.346[/TD]
[TD]0.087[/TD]
[TD]0.787[/TD]
[TD]0.257[/TD]
[TD]0.317[/TD]
[TD]0.001[/TD]
[TD]-0.001[/TD]
[TD]0.318[/TD]
[TD]0.691[/TD]
[TD]0.232[/TD]
[TD]Sum[/TD]
[TD]96[/TD]
[/TR]
[TR]
[TD]0.687[/TD]
[TD]-0.002[/TD]
[TD]0.544[/TD]
[TD]0.052[/TD]
[TD]0.344[/TD]
[TD]0.752[/TD]
[TD]0.113[/TD]
[TD]0.691[/TD]
[TD]0.470[/TD]
[TD]-0.002[/TD]
[TD]0.481[/TD]
[TD]-0.002[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.000[/TD]
[TD]0.340[/TD]
[TD]0.252[/TD]
[TD]0.411[/TD]
[TD]0.293[/TD]
[TD]0.238[/TD]
[TD]0.371[/TD]
[TD]0.267[/TD]
[TD]0.712[/TD]
[TD]0.705[/TD]
[TD]-0.002[/TD]
[TD]0.003
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.001[/TD]
[TD]0.321[/TD]
[TD]0.274[/TD]
[TD]0.424[/TD]
[TD]0.250[/TD]
[TD]1.489[/TD]
[TD]0.600[/TD]
[TD]0.801[/TD]
[TD]0.296[/TD]
[TD]0.056[/TD]
[TD]0.008[/TD]
[TD]0.000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.318[/TD]
[TD]0.180[/TD]
[TD]0.087[/TD]
[TD]0.306[/TD]
[TD]0.010[/TD]
[TD]0.329[/TD]
[TD]0.323[/TD]
[TD]0.288[/TD]
[TD]0.335[/TD]
[TD]0.263[/TD]
[TD]0.011[/TD]
[TD]0.217[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.241[/TD]
[TD]0.154[/TD]
[TD]0.322[/TD]
[TD]0.183[/TD]
[TD]0.733[/TD]
[TD]0.001[/TD]
[TD]0.321[/TD]
[TD]0.726[/TD]
[TD]0.213[/TD]
[TD]0.308[/TD]
[TD]0.005[/TD]
[TD]0.299[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.744[/TD]
[TD]0.263[/TD]
[TD]0.344[/TD]
[TD]0.482[/TD]
[TD]0.514[/TD]
[TD]0.276[/TD]
[TD]0.286[/TD]
[TD]0.278[/TD]
[TD]0.229[/TD]
[TD]0.370[/TD]
[TD]0.389[/TD]
[TD]0.780[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.001[/TD]
[TD]0.390[/TD]
[TD]0.245[/TD]
[TD]0.186[/TD]
[TD]0.070[/TD]
[TD]0.010[/TD]
[TD]0.298[/TD]
[TD]0.271[/TD]
[TD]0.291[/TD]
[TD]0.352[/TD]
[TD]0.000[/TD]
[TD]0.646[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.222[/TD]
[TD]0.144[/TD]
[TD]0.335[/TD]
[TD]0.000[/TD]
[TD]0.348[/TD]
[TD]0.248[/TD]
[TD]0.708[/TD]
[TD]0.450[/TD]
[TD]0.344[/TD]
[TD]0.301[/TD]
[TD]0.096[/TD]
[TD]0.007[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.281[/TD]
[TD]0.331[/TD]
[TD]0.348[/TD]
[TD]0.687[/TD]
[TD]0.330[/TD]
[TD]0.301[/TD]
[TD]0.079[/TD]
[TD]0.381[/TD]
[TD]0.430[/TD]
[TD]0.308[/TD]
[TD]0.185[/TD]
[TD]0.007[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0.000[/TD]
[TD]0.592[/TD]
[TD]0.677[/TD]
[TD]0.322[/TD]
[TD]0.288[/TD]
[TD]0.113[/TD]
[TD]0.357[/TD]
[TD]0.263[/TD]
[TD]0.239[/TD]
[TD]0.198[/TD]
[TD]0.736[/TD]
[TD]-0.001[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]