Getting Pivot Tables to automatically sort rows in alphabetical order
Hi
Is there a way, whether it be by VBA or on pivot table properties where
I can get pivot tables to automatically sort data in alphabetical order
everytime I press refresh. For some reason, any new people that I add
on my sheet after the table was produced gets tacked at the bottom. IE
Original Data - this is how data looked like when data was produced
Apples Pears Peaches
Bob 2 3 1
Harry 3 2 1
James 1 0 3
Jim 1 4 2
This is what happens when I add new data and press refresh:
Apples Pears Peaches
Bob 2 3 1
Harry 3 2 1
James 1 0 3
Jim 1 4 2
Andy 1 4 2
Barry 2 3 1
Desired result when I press refresh is
Apples Pears Peaches
Andy 1 4 2
Barry 2 3 1
Bob 2 3 1
Harry 3 2 1
James 1 0 3
Jim 1 4 2
Thanks in advance
K/
|