Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to create a macro to handle this problem

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •