S shanan New Member Jan 30, 2015 #26 Hi, It's working fine. Thanks is there any possibility to make the Pivot run in macro as well, means to create pivot and sort it by macro itself? It will make alot easier for the user, that's why. Thanks
Hi, It's working fine. Thanks is there any possibility to make the Pivot run in macro as well, means to create pivot and sort it by macro itself? It will make alot easier for the user, that's why. Thanks
N Nebu Excel Ninja Jan 30, 2015 #27 In the button click event after the line Dim rng As Range try putting the code thisworkbook.refreshall I guess it will do the trick Thanks
In the button click event after the line Dim rng As Range try putting the code thisworkbook.refreshall I guess it will do the trick Thanks