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:

 FinalRow = WSD.Cells(Application.Rows.Count, 1).End(xlUp).Row
    FinalCol = WSD.Cells(1, Application.Columns.Count). _
        End(xlToLeft).Column
    Set PRange = WSD.Cells(1, 1).Resize(FinalRow, FinalCol)

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

=OFFSET(NE_IDEA_List_of_Open_Purchase_O!$A$1,,,COUNTA(NE_IDEA_List_of_Open_Purchase_O!$A:$A),COUNTA(NE_IDEA_List_of_Open_Purchase_O!$1:$1))

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