Hi all,
I've done a lot of searching and have tried to piece something together, with no luck, based on other responses. I know there are a lot of threads on the subject of filtering a pivot table with VBA, but my biggest challenge is that most macros are referencing a specific pivot table, a specific field, and/or a specific range where a list is stored.
Ideally, what I'd like to do is:
Start macro and
1) Have user select a field in a pivot table that is to be filtered, and then
2) Have user select a range where a list is stored
I can't quite mesh everything together where it can be any user selectable field in a pivot table based off a list that can be in any location and of any varying length. I'm hoping this isn't an impossible dream!
Thanks!!
Oh, and I'm using Excel 2010.
I've done a lot of searching and have tried to piece something together, with no luck, based on other responses. I know there are a lot of threads on the subject of filtering a pivot table with VBA, but my biggest challenge is that most macros are referencing a specific pivot table, a specific field, and/or a specific range where a list is stored.
Ideally, what I'd like to do is:
Start macro and
1) Have user select a field in a pivot table that is to be filtered, and then
2) Have user select a range where a list is stored
I can't quite mesh everything together where it can be any user selectable field in a pivot table based off a list that can be in any location and of any varying length. I'm hoping this isn't an impossible dream!
Thanks!!
Oh, and I'm using Excel 2010.