macro on pivot tables / pivot items
On 5$B7n(B8$BF|(B, $Be8a(B3$B;~(B13$BJ,(B, wrote:
On 5$B7n(B8$BF|(B, $Be8a(B2$B;~(B54$BJ,(B, wrote:
Still show error message 1004 when success to split out on the first
of PivotField
name....(only success save 1 file)
But the format are ok, how the split out file need the drill data?
How can i do? Can I run the Pivot Table's name (Sheet name) instead
of PivotTable1?
I know that why show error 1004, because the second pivotfield name is
no data, so the marco cannot save a file without the name...
Now can i do?
Hi Bernie,
How can get the drill data from split file of Pivot table, because
each person need the detail of records. Thanks!
|