• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table - Display and sort column labels

V

Villalobos

Active Member
Hello,

I would like to ask that is there any kind of way to display all column labels of pivot table and then sort them by ascending order thru VBA (after refreshing)?
 

Attachments

  • Sample.xlsm
    13.4 KB · Views: 0
Hi ,

Just switching the row and column labels should help. See the file.

Narayan
 

Attachments

  • Sample (1).xlsm
    13.3 KB · Views: 1
Hi Narayan,

Thank you for your time. Maybe I was not enough clear, I do not want to switch the position of row and column labels. The "Material" has to be row label always, and the "Date/week" has to be column label always as well. My problem is that after I refresh (with new set of data) the data source of pivot table I have to select and move manually some column labels to the right position. My target would be that to avoid the manual selecting and moving of column labels.
 
You must log in or register to reply here.
Back
Top