hi,

i have a pivot table, and would like create a button where when pressed, it will run a specified set of search filters across the 10 odd columns I have.

i also need a button that when pressed, makes the pivot table 'show all' in all its fields again, so I don't have to manually go back and tick 'show all' in each column. I found some macro scripts on the net but couldn't get them to work properly, excel would just spaz out, maybe because theres 4000 odd rows to search through? I don't know.

But anyway, would really like 2 macro's to run this. My pivot table has 4000 rows, and 10 columns with the pivot table filters. So to summarise - would like a button that when pressed, automatically ticks tick boxes to search for criteria, and another button that resets everything again.

can this be done?