+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Help with merging tables

  1. #1
    Registered User
    Join Date
    11-28-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    3

    Help with merging tables

    Hello,
    i am not advanced Excel user and have problem to solve.
    I have n amount of tables and i want to merge them in one.
    My tables looks like that

    Name | Points
    abc | 123
    I want somehow to make it automatically IF Name repeats to sum its Points under one field.
    Thank you in advance

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Help with merging tables

    It sounds like you need a pivot table, if you can attach a sample workbook, I'll have a look

  3. #3
    Registered User
    Join Date
    11-28-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help with merging tables

    I will rewrite my workbook in English so you can understand.
    EDIT: Attached file in English. Every week i calculate points from 5 sheets and sum everything in last sheet.
    Attached Files Attached Files
    Last edited by PilnaTroba; 11-28-2011 at 09:32 AM.

  4. #4
    Registered User
    Join Date
    11-28-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help with merging tables

    I know it is not appropriate way to do it, but since i edited my last post maybe no one noticed attachment.

+ 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