Hi

Is it possible to auto program a pivot to select certain months within a
list selected on a user form so that the Pivot can be updated to these months

eg i select 3 or 4 months on my worksheet from a multiselect list which
updates a pivot on another worksheet without the need to manually select the
sheet and then selecting the pivot table.

any help would be greatfully appreciated

thanks

Rivers