Hello
I have a workbook with multiple Pivot Tables.
The name of each Pivot table contains the word "week" or the word "month".
I need you to do a form for year, month, week, "company" and "type", selection.
With this selection, you must:
1- fill a cell with selected
2- apply selection in many pivot tables. If pivot table contains the word "week", then you must apply "week" selection, and if contains "month", then apply month selection.
3- apply company and type selection to all the Pivot Table.
One of the sheets, will contain the list of years, month, week, company and type.
In all the if statement, if a field does not exist, then resume next.
The form must open with a button.
Must run in Office 2007 and XP.
You must do it using VBA (open code).
Scrow Payment.
If you are Excel expert, then this may take max 4 hours
Thanks