The enclosed file is an extract from a far bigger file which has data added on a regular basis. On the second tab I have created a Pivot table to show cost for a particular month by location. What I would like is for this data to automatically sort by cost is descending order. ie: so that Willesden T.M.D is at the top. Can someone tell me how this can be done. and so it works on whatever month I choose. Thanks Kevin.
Very simple. Click on the column containing the $, for e.g. $811.21. And then right click, select Sort->Sort Largest to Smallest.
This will give you Willesden T.M.D at the top.
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks