+ Reply to Thread
Results 1 to 2 of 2

Using a pivot table to display all the columns from the original table for the selected ro

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    2019 pro

    Using a pivot table to display all the columns from the original table for the selected ro


    I have a spreadsheet that has 11 columns of information. The headings to the columns are : -

    Job Number, Project, Electrical eng, Mechanical Eng, Project Manager, Director, Status, Client, Contractor, and a few more columns

    Under the Electrical engineer we put the initials of the electrical engineer for each project. There are 4 electrical engineers in total
    Under the Mechanical Engineer we put the initials of the Mechanical engineer allocated to each project. There are 5 Mechanical engineers in total,
    Same for the Project managers, - we have 6 of these
    And same for the Directors,we have 2 of these.

    We then want to display on separate spreadsheets in the same workbook the jobs allocated to each electrical and mechanical engineer, each project manager and each director.

    We do not want to do any maths or calculations on the data. Just display all the fields for each job allocated to each engineer , Project manger and director in separate little tables.
    Attached Files Attached Files
    Last edited by Vaderalan; 07-28-2020 at 11:04 AM. Reason: Did not add the attachment

  2. #2
    Registered User
    Join Date
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Hello Vaderalan,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Only display pivot table items that meet ALL selected slicer criteria?
    By GregStewartPTC in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-23-2020, 01:11 PM
  2. Pivot table to display in rows not columns
    By halefamily104 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2017, 02:53 PM
  3. Replies: 11
    Last Post: 04-29-2017, 07:23 PM
  4. Replies: 1
    Last Post: 05-14-2016, 03:05 PM
  5. pivot table display data in separate columns
    By Hidai in forum Excel General
    Replies: 6
    Last Post: 01-05-2011, 02:14 PM
  6. Replies: 2
    Last Post: 11-03-2009, 03:30 PM
  7. Display cell color from original data in pivot table
    By Shadmani in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 07-08-2009, 01:34 PM


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