I have a PivotTable that has one filter in the header. That filter has 1000 choices. I would like to sequentially select one of those at a time, refresh the PivotTable and save the active sheet to a PDF using Excel 2007 - continue to the next until finished with the list. I am decent with VBA, but have no idea where to start with a PivotTable VBA. Thoughts?