Forum Discussion
John23785
Sep 10, 2024Copper Contributor
Search and Filter Pivot Table
Hello - I am working on two separate files. One is a pivot table with 50K rows, the other is a static excel file with ~200 rows. I'm trying to obtain information from the pivot table easily into the ...
John23785
Sep 10, 2024Copper Contributor
Update: a Filter formula did the trick, is there a way to avoid spill but drag down the 200 rows to capture them all?