+ 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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    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.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. 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