how can i create a macro for creating a pivot table.

[shekar goud]

Hi,

I have data in sheet1 called "Daily data" and in the next sheet the pivot should be create and there starts my problem.... I have to put "Region","Function",and "Manager" in the row fileds of Pivot and in column the count.

I have to put filter on Row Pivot Fileds for Region and unselect all feilds execpt "Stamford" and likewise for Function only "Repo".

I Have no idea but just recorded a macro is giving an error.

Please help me out ..would be Highly Appreciated.

Please Login or Register  to view this content.

Thanks for any Help....

[Andy Pope]

Perhaps some detail on the error would help us help you.

[shekar goud]

Hi Andy,

Iam begginer to this Macro programming.But iam sure my entire code have some problem and the error is Run time -1004 states "Unable to get the PivotFields property of the PivotTabel class".

Thanks Very much for your intrest Any.


Regards,
Shekar.

[Andy Pope]

which line in your code?

Perhaps you can post example workbook.

[shekar goud]

Hi Andy,

I just tried to record once again the macro.

Please Login or Register  to view this content.

Even you can find an attached xls sample file please help on this issue.

Regards,
Shekar.

[Andy Pope]

Even you can find an attached xls sample file please help on this issue.

where would I find this example file??

[shekar goud]

Hi Andy,

Please find attached zip file.





Regards,
Shekar.

[Andy Pope]

The data source in your code is incorrect. This means that the fieldnames are also incorrect.

This change sorts out the problems.

Please Login or Register  to view this content.

[shekar goud]

Brillant thanks very much Andy....