hi,

I have a spreadsheet with a pivot table and linked chart. My objective is to automate the following steps from beginning to end.

1 - Change pivot table filter to the first name on the list
2 - Once chart and table are updated, print worksheet
3 - Go to next name down in the filter and repeat step 2
4 - Continue until last SKU in the pivot table filter reached - end
Thanks in advance