Forum Discussion
Script to copy selected filtered Excel pivot table columns to another excel tab?
Hello, I have been filtering different views of my base Pivot table (based on the 4 different Age categories present in my dataset) and copying selected columns over to a new Excel tab to show th...
Why not just copy the entire pivot table twice and filter each of them accordingly? That way you only have to do this copy once. After that, a refresh all suffices.