Hi, gurus,
I'm coding to manipulate power pivottable but ran into a problem.
The issue is how to assign the latest date in table "Dates" to the page filter "Date" of ppvt, ie "2020/3/23" to Sheet2!C2.
It seems many attributes or references of ppvt is waaaaaaay different from normal pvt
Pls see attached file with mock-up data.
Thank you for your help and take care, stay safe!
Bookmarks