+ Reply to Thread
Results 1 to 4 of 4

SUM alternate rows after specific block

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,802

    SUM alternate rows after specific block

    Hello everyone

    In the attachment run the code 'Test' and notice the rows 36 and 37 (these rows have the totals of alternative rows and these results are correct)

    Please Login or Register  to view this content.
    What I need to do is to insert the same result after another 30 rows >> so in rows 69 and 70 I expect to have the same result as rows 36 and 37
    And also at the end of data I need to have the totals too as explained

    * In brief, I need to have the same results as in rows 36 and 37 for each block of 30 rows and also the totals at the end of data

    Hope this is clear now

    The thread is posted here too
    http://www.eileenslounge.com/viewtopic.php?f=30&t=31362
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,401

    Re: SUM alternate rows after specific block

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,802

    Re: SUM alternate rows after specific block

    Thank you very much Mr. AlphaFrog
    Please have a look at the yellow rows .. in the yellow rows after each 30 rows. I need to have results of getting totals alternatively as in rows 36 and 37
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,802

    Re: SUM alternate rows after specific block

    The problem solved at this link
    http://www.eileenslounge.com/viewtop...art=20#p242804

    Thanks a lot Mr. AlphaFrog for your sharing the issue
    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy and paste specific range to date specific range in alternate sheet
    By alanalmarza in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 08:29 AM
  2. [SOLVED] block only specific cells
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-21-2012, 10:59 AM
  3. Replies: 5
    Last Post: 10-09-2012, 10:44 AM
  4. [SOLVED] VLOOKUP formula that will relatively adjust rows by a block of 8 rows with absolute column
    By DPKologie in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 09-02-2012, 04:00 AM
  5. using the mod function to alternate rows
    By withy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2009, 05:31 AM
  6. how do you add up alternate rows in the same column?
    By adrian078 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-29-2007, 12:25 AM
  7. Add alternate rows
    By Teri in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1