5 Replies Latest reply: Nov 2, 2010 8:26 AM by filipemcmanus RSS

loop and print selection



I have a pivot table which displays information about sales, variance, profit etc. Those information are based on a department selection, so for example when user selects frozen department, it will display information only about that department. There are about 10 departments overall.

Is it possible to create a button, which will loop through those 10 departments, and print out sheet with pivot table for each department?