I have a xlsm file where I use VBA to import, sort and filter data each day. I also have a 14 day pivot chart slicer which I manually turn on the latest information and turn off the data of of anything greater than 14 days.
So my question is; can this be automated through VBA so that it selects and displays only the last 14 days of information?
I would appreciate any assistance on this matter
Start by recording a macro.
You can control state by using the Selected property.
activeworkbook.SlicerCaches("Slicer_Column3").sliceritems(1).Selected = False
Andy - many thanks for the response - I did managed to do the easy bit, but its the bit afterwards that I am struggling with that selects only the most current 14 days
can you post example file.
Andy - Our security systems prevent me from uploading an excel file. Is there any other way you could receive this information? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks