| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| overlapping pivot tables | Excel Discussion (Misc queries) | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Discussion (Misc queries) | |||
| Pivot Tables & not printing blank rows (revisited) | Excel Worksheet Functions | |||
| Hiding rows containing zeroes or blanks in pivot tables? | Excel Discussion (Misc queries) | |||
Threaded Mode
