Raf has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Debug of pivot tables
the sales person table doesn't work if the name has already appeared
RE: debug of pivot tables
Hi Raf,
Thanks for the question.
I am in the office tomorrow so I will go through the code and find out why the code was not executing a new sheet and pivot table for existing tabs.
Regards
Simon
RE: debug of pivot tables
Hi Raf,
In regards to my last email, our upload link does not allow macro enabled files to be attached.
If you would like the amended code, just send me an email address.
Regards
Simon
RE: debug of pivot tables
Hi Raf,
I have looked at the code and amended the following:
1. I uncommented the Call Delete sheet line of code in the CreateSheet procedure.
2. In the MainSPReport there was no line of code calling the PivotAnalysis so I added it in.
If you are using the command button, you need to comment out the Call PivotAnalysis as we have the blnPivot = true then call PivotAnalysis.
Please find the amended code attached.
I hope this answers your question.
Regards
Simon
