Create a Pivot Table with VBA

Hello,

I'm trying to write a code that will create a pivot table. I'm try to do this using a pivot table cache, but I can't seem to be able to get it working the way I want to.

The attached workbook has two spreadsheets. The first sheet is a set of data, the second is the hoped-for pivot table. I'd like to have a code that generates this pivot table (the generated pivot table should be in a separate worksheet from the data). The row labels = city, values = count of Number of Complaints, values = sum of Number of Complaints.

Thank you for any ideas on how to make this work. I greatly appreciate it!