Debbie in PA
New Member
- Joined
- Mar 28, 2002
- Messages
- 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
Any help is greatly appreciated.
Thanks.
Debbie