Hi All.
I want to move record from "MOU sheet" to Pivot based on condition as when column "O" is blank.
I use the below macro. Its working fine but it hides all rows after the macro run.
Can you please check any issue in the program.
Please Login or Register to view this content.
Thanks
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you sintek. Its working fine. one more query.
Is there any possibility to refresh pivot table automatically in every 2 hours without running vba. .Any suggestion is highly appreciated.
I used this code for pivot refresh but it is not working on all pivot. is it possible to change from activesheet to all sheet in workbook.
Please Login or Register to view this content.
Last edited by sarat47; 07-06-2018 at 11:24 PM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks