I compile a large flat table-datasheet using slicers to pull from a pivot table; I also have a table with criteria that dictate which slicers to pick for each row of data. I am wondering if a macro can look at the sheet row by row and based on the data in the row it goes and chooses the appropriate slicers for me? this way I dont go through 200+ lines one by one choosing the right slicers based on the line and then copying the results and pasting them into the flat table datasheet
Bookmarks