+ Reply to Thread
Results 1 to 4 of 4

Need to sort pivot table's column labels by type

  1. #1
    Registered User
    Join Date
    06-02-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    75

    Need to sort pivot table's column labels by type

    I need VBA macro/code to move the column labels; called activities; and group them by their activity type.
    The activity types (i.e. regular, project, or other activity) for all activities are shown in the "Data" worksheet"
    I need to sort/move the headers by grouping them regular, project, then other activities together..
    I am attaching the file. I appreciate any help.. Thanks
    pvtb.xlsm
    Last edited by adelkam; 02-19-2015 at 10:47 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need to sort pivot table's column labels by type

    You are looking for this lay out?

    See the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    06-02-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    75

    Re: Need to sort pivot table's column labels by type

    Thanks oeldere.. sounds like a good idea!!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Need to sort pivot table's column labels by type

    Thanks for the reply.

    Glad I could help.

+ 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. Pivot Table Row and Column Labels
    By srizki in forum Excel General
    Replies: 0
    Last Post: 11-06-2014, 04:38 PM
  2. Control Pivot table Column labels by cell reference
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2014, 06:00 AM
  3. Pivot Table - Show Row labels horizontally (Not as Column labels)
    By Catsup in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-16-2014, 01:15 PM
  4. Replies: 0
    Last Post: 07-03-2012, 11:09 AM
  5. Pivot table Sort by Row Labels
    By shabz in forum Excel General
    Replies: 7
    Last Post: 04-03-2012, 12:32 PM

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