Hi,

Why don't you show us the code and tell us where it fails?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"massa" wrote:

I have a group of people that access an excel spreadsheet that
containsaccounting data for each ones clients.Each person pulls their data
out of the spreadsheet and copies it to another sheet for review. I would
like to create a macro that will drop their data automatically into a pivot
table and then create a pivot chart. Can someone assist? When I try to record
this I get an error ref the pivot table.