How to create a macro to handle this problem

Debbie in PA · Mar 29th, 2002, 04:29 PM

I have about 13,000 rows of data that need to be processed. I separate the data by inserting a blank line after each "set" of samples. One sample may have 3 rows of data, another may have 10, another may have 5 or 6 or even 1. I want the macro to count the rows until it encounters the blank line that I've inserted between the data. Then I need it to average the rows it has counted and put the average in the row just beneath the data it is associated with and then insert a new blank line (to make the data easier to read), then continue to the next row, start counting again and repeat the same process. I was using a macro that had a set number of lines which worked fine when each sample only contained 3 rows of data and everything was consistent.
Any help is greatly appreciated.
Thanks.
Debbie

Yogi Anand · Mar 29th, 2002, 04:40 PM

Hi Debbie:
Have you tried DATA|SUBTOTALS ...
I think your problem fits nicely into its capabilities.

Mar 29th, 2002, 04:40 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Debbie: Have you tried DATA\|SUBTOTALS ... I think your problem fits nicely into its capabilities. __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 29th, 2002, 04:29 PM	#1
Debbie in PA New Member Join Date: Mar 2002 Posts: 1	I have about 13,000 rows of data that need to be processed. I separate the data by inserting a blank line after each "set" of samples. One sample may have 3 rows of data, another may have 10, another may have 5 or 6 or even 1. I want the macro to count the rows until it encounters the blank line that I've inserted between the data. Then I need it to average the rows it has counted and put the average in the row just beneath the data it is associated with and then insert a new blank line (to make the data easier to read), then continue to the next row, start counting again and repeat the same process. I was using a macro that had a set number of lines which worked fine when each sample only contained 3 rows of data and everything was consistent. Any help is greatly appreciated. Thanks. Debbie