Hi All,
I need a code that will do this: if the total is positive then sort descending and if it's negative, then the pivot column (just one column) will be sorted ascending. but the number of lines may change though so the total might not always be in the same cell every day
Do you have a sample file that you can upload?
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]
So i attached the file. and is it possible to add another sheet with another pivot with different column headers say sheet 1 pivot 1 would be as is, then copy that sheet rename it and change the headers with Test 1 and test 3, then another one with test 3 and 4, so on and so forth
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks