+ Reply to Thread
Results 1 to 2 of 2

Pivot table consolidating employee weekly timesheets

  1. #1
    Registered User
    Join Date
    08-06-2020
    Location
    Honolulu, Hawaii
    MS-Off Ver
    2013
    Posts
    1

    Pivot table consolidating employee weekly timesheets

    Hello,

    I have created weekly time sheets for our employees which contain job numbers, phase codes, labor categories, rates, etc. I am trying to determine the best way to consolidate all of the data from the various sheets into one sheet that shows the total man hours per job, per phase code. Any ideas?

    Thanks for your help.
    Blake

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,704

    Re: Pivot table consolidating employee weekly timesheets

    Load the tables into Power Query and Append each. Then Group the data by job. If you wish to see this in action, supply some sample sheets and expected results.

+ 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. Replies: 4
    Last Post: 08-25-2016, 03:32 PM
  2. [SOLVED] Need help creating and consolidating a pivot table
    By tejasjeorge in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-13-2015, 11:29 AM
  3. Consolidating Pivot Tables into 1 pivot table - is this possible?
    By levitt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-20-2013, 04:10 PM
  4. [SOLVED] Need to aggregate employee timesheets into a summary sheet
    By cfell in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-23-2013, 02:03 PM
  5. Consolidating data for pivot table
    By floricita in forum Excel General
    Replies: 0
    Last Post: 09-01-2010, 09:03 AM
  6. [SOLVED] Consolidating multiple external pivot tables into one pivot table
    By Exiled in forum Excel General
    Replies: 1
    Last Post: 08-13-2006, 07:51 AM
  7. Pivot Table - consolidating ranges (again)
    By xman in forum Excel General
    Replies: 3
    Last Post: 09-18-2005, 10:05 AM

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