Hi guys,
I am new here in this forum and also learning macro. I have a power pivot that has dates in m/d/yyyy format. I want to select only those dates in slicer which are available in another sheet. There are only 8 dates. Any macro code for this pls share.
Hi Pawan
Welcome to the Forum. What do you want to do with the dates after selecting them. Ideally an upload of a sample file depicting a before & after will assist us in finding a solution to your enquiry.
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!!!
Hi Sintek,
Thanks for your reply.
Well i have created view which will take a value from pivot through getpivot but each week when i will refresh the report I will update a cell with latest date and based on that date last 8 dates which will auto calculated in a same tab need to be selected in slicer. I am sorry but i won't be able to share data as it is very confidential.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks