Forum Discussion
VBA Macro to write to Pivot table "Search" filter
Hi everyone, I have a requirement for a code to copy data from a cell in a workbook & paste the value into the search field of a pivot table. Just to illustrate, I want to copy the data from wor...
You may want to try recording a macro. During recording, do that action that you need done, then stop the recording. Take a look at the code that was generated and adjust it accordingly to meet your needs.
Better to take some sample and adjust it to own needs, google returns quite many, e.g. https://www.mrexcel.com/forum/excel-questions/734700-update-pivot-table-filter-based-value-another-cell.html
I'm myself never did such filtering and can't give concrete advice