Question Issue creating pivot table from table data

Hi guys,

I almost have this piece of code working exactly as I want it to. My only issue is that I want the pivot table to be created on an existing worksheet called "Client Distribution" instead of the macro creating a new worksheet to put the pivot table in. Does anyone know how I can fix this? When I try to change the destination worksheet (you can see it commented out in the code) it gives me an error on the very last line of code. I would really appreciate any help!

Please Login or Register  to view this content.

Hi Guys,

I was able to get some help on Reddit. Turns out the issue was that my worksheet name had spaces in it which was causing problems. I needed to put a single quotation around the worksheet name to make it work. I change the last line of code out for this.

Please Login or Register  to view this content.