+ Reply to Thread
Results 1 to 9 of 9

Summary Details with 2 colums

  1. #1
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Summary Details with 2 colums

    Hi All

    I have data in sheet "Detail" with Table in column Q to AD and values in column S

    and VBA is below is working well, now, if i need this VBA to include more summary in column AH

    how to adjust it?

    Please Login or Register  to view this content.
    Thanks advanced for help
    Attached Files Attached Files
    Last edited by yukioh; 01-24-2016 at 01:51 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Summary Details 2

    Change this line
    Please Login or Register  to view this content.
    INTO

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Re: Summary Details with 2 colums

    Hi AB33 and all,

    I have change as you guide, the result is ok, but still see the duplicate information

    the current VBA will summary and no duplicate information

    Untitled.png
    Last edited by yukioh; 01-24-2016 at 01:48 AM.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Summary Details with 2 colums

    It is difficult to see the output in a picture. Try the attached.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Re: Summary Details with 2 colums

    Hi AB33,
    It seems that, the result is lost data, data not come all, in columns B = ACC with COX1 ,COX9 and COX10, should have more than 1 line

  6. #6
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Summary Details with 2 colums

    I do not know what you are looking for. You have asked to adjust the columns.
    Look at the original out put in sheet SUM (2). You should attached your output result. What needs to be changed from the original output?

  7. #7
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Re: Summary Details with 2 colums

    Hi AB33,

    Yes, I have attached the output result file in sheet(SUM2 Sample) below:

    sorry for my mistake
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Summary Details with 2 colums

    Try the attached.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    10-29-2012
    Location
    Laos
    MS-Off Ver
    Excel 2003,2010,2013
    Posts
    126

    Re: Summary Details with 2 colums

    Hi AB33,

    Now, It's working

    Thank you so much for your kindly suggest and support.

+ 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. [SOLVED] Summary Details
    By yukioh in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-17-2016, 11:20 AM
  2. Need to create summary report based on info available in Details Sheet
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-09-2014, 03:24 PM
  3. Replies: 2
    Last Post: 10-09-2014, 05:18 AM
  4. Automatically include details from new worksheet in summary worksheet
    By shez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 07:23 AM
  5. Replies: 6
    Last Post: 11-15-2012, 09:39 AM
  6. Replies: 0
    Last Post: 08-21-2012, 01:19 AM
  7. Automatically enter details in Summary sheet when new sheet created
    By unley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2010, 05:13 PM

Tags for this Thread

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