M
Mouimet
Hi,
IN VBA how can I select only the data I need in the Pivot Table Page section.
Need to get only the data <45 in column "Days"
"Days" is in the Page Section of the pivottable.
The user will only click a button to answer different questions, and
generate a new data sheets base on is criterias and then, the pivot table is
refresh. the user will not select any other data.Most of the macro is ok. My
problem is only selecting the <45.
On the Page fields the pivot table should always select "DAYS" <45. from the
data.
I tried different macro and I can't find the solution.
I found something usefull on the newsgroups however when the macro do not
see any data smaller than 45 it stop with an error message.
Please help. Thanks
IN VBA how can I select only the data I need in the Pivot Table Page section.
Need to get only the data <45 in column "Days"
"Days" is in the Page Section of the pivottable.
The user will only click a button to answer different questions, and
generate a new data sheets base on is criterias and then, the pivot table is
refresh. the user will not select any other data.Most of the macro is ok. My
problem is only selecting the <45.
On the Page fields the pivot table should always select "DAYS" <45. from the
data.
I tried different macro and I can't find the solution.
I found something usefull on the newsgroups however when the macro do not
see any data smaller than 45 it stop with an error message.
Please help. Thanks