+ Reply to Thread
Results 1 to 5 of 5

Summarizing data from multiple sections

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    18

    Summarizing data from multiple sections

    Dear Excel gurus,

    I have a workbook with data sections separated by an empty row, where I'd need to summarize some data to new columns, I have attached a workbook with two worksheets.

    First sheet contains the data how it is currently, and the second worksheet is an example how the macro should summarize the desired data from columns D & E.

    The rows per section vary from 3-6.

    Please see attach example

    example.xlsx

    Edit: First sheet does not have the extra columns for generated numerical data, don't get confused by this
    Last edited by tuppari; 10-21-2012 at 01:49 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Summarizing data from multiple sections

    You will need to explain how you calculate the 2's and 0's.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-10-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Summarizing data from multiple sections

    Oh yeah.

    Well besically I need to count the amount of DI's and CR's from column E per every unique unit from column D (From a range of data separated by an empty row)

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Summarizing data from multiple sections

    So you want columns F - I to be populated by the macro?

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Summarizing data from multiple sections

    try
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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