Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
70
Views
Topic starter
Hi all
Is there a way that PowerPivot/VB Code can automatically be sorted descending on the last column in the table when refreshing data? Each week new data gets added and I would like to see if there is a solution that will always allow the last column to be sorted. (not the Grand Total).
Thank you for any help and support,
- Mike
Posted : 13/01/2018 3:04 pm
Hi Mike,
Please provide a sample file so I can see your structure, there is no generic code that can detect your layout, there are so many possible combinations.
Thanks for understanding.
Posted : 14/01/2018 3:02 am
