Results 1 to 4 of 4

Extracting and comparing information from pivot table.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Extracting and comparing information from pivot table.

    Hello experts, I have some data that I have created a report from. However it doesn't show a "true" picture for the stat we want. I have a pivot table set up with data showing the hours worked for an individual. What I am wanting to do would be to cross reference the data but not sure how to compare data. I have provided some make shift data to see if it is even feasible. The end goal is to get a true picture of P.P.H The data we are able to get is in a horrible format. I would eventually like to automate this in VBA but will work on the later. I thought about doing a vlookup but the is no real matching data for all employees. Some of the names are wrong in one system and there is no matching emp ID. Very disorganized. Anyways thoughts or suggestion on the best approach to tackle this project would be.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extracting Information From 8 Fields in excel and Placing it into a Powerpoint Table
    By Wesley0705 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2013, 11:50 PM
  2. Heat Mapping by row for a table of information (or a pivot table)
    By jacebailes in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-06-2013, 06:22 PM
  3. Extracting Data from Pivot Table
    By usmanfarok in forum Excel General
    Replies: 0
    Last Post: 05-14-2012, 10:30 AM
  4. Extracting Data from a Pivot Table and comparing
    By mwburne@yahoo.c in forum Excel General
    Replies: 1
    Last Post: 10-19-2007, 08:31 AM
  5. Extracting Information from A Pivot Table
    By Jim Patterson in forum Excel General
    Replies: 2
    Last Post: 06-16-2006, 08:00 AM

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