+ Reply to Thread
Results 1 to 2 of 2

Look for unique info in column A, show sum from multiple columns

  1. #1
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Look for unique info in column A, show sum from multiple columns

    Ok, so the title is a tad cyrptic!!

    Workbook is a time sheet for 14 departments(i created it and all aspects of it in my own time at home so the sheet is mine)
    Layout is identical on each tab.
    )olumn B in each sheet contains employee name for that area (ranging from B9:B70)
    Column Y in each sheet displays total hours worked for that area (ranging from Y9:Y70)

    I would like another 'Summary' sheet that would look at column B (range B9:B70) on every sheet, and then show me all unique names (so no duplicate names) in one column, in another column i would like the same thing, but this time a sum of all hours worked for that name, taken as a sum from all the sheets where the name appears.
    I also do not know if this would be better being done via macro??

    I will work on clearing personal info from the workbook to load a sample.

    Kind Regards.
    galvinpaddy

  2. #2
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: Look for unique info in column A, show sum from multiple columns

    Hi, quick update.
    I have marked this as solved and moved it to the correct section as i think it needs a macro.

    ***MOVED TO VBA SECTION***

+ 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