macro for dynamic pivot table

[arnab0711]

Hi,
Want to create a macro for a pivot table as in the "dynamic" file,pl note the row count will change every day,hence the pivot table will be dynamic in nature.

[royUK]

Create a Dynamic Named Range for the data

[arnab0711]

Hi,
The formula is not working over here, pl avice the macro code for it.

[royUK]

Not very informative at all. Which fromula isn't working?

Have you converted your data to a Dynamic Named Range , then used the name for the PivotTable?

Which version of Excel are you using?

[Xrull]

arnab0711,

I think the code for the pivot code you provided in your previous post has a dynamic range built in:

Please Login or Register  to view this content.

Name this formula, and place it in the same file you uploaded in this post:

Please Login or Register  to view this content.

Then right click on the pivot, and click back, then paste the name in the Range: box.
By the way, was the solution I provided for your previous post helpful?
If so, please mark it as solved.

Regards,
Xrull