Thank you! I often figure stuff out myself by recording a macro and watching how Excel builds it. Unfortunately, I kept getting errors using the ws.PivotTables.Add method that macro used. This tutorial helped a lot! Thank you!
Hi Jie, Thanks for your video! I managed to replicate your procedure and get a nice pivot table! I wonder if it is possible to create multiple pivot tables for specific combinations of variables appearing one after the other (vertically) in the same sheet. For example using a list box where user can select one variable from a table (say Var1) and another listbox where user can select multiple variables from the same table (Var2, Var3, ...). Then creating a pivot table for each combination of those variables, where the single selected Var1 is always displayed on columns and the others horizontally. This will need to account for the size of every table so they dont overlap. I thought this may be a recurrent task but can't find any ressources out there. Thanks in advance!
Hi Jie, That was some great stuff that you posted. thank you. I have a question though- is it possible to give dynamic fields in the Pivot under columns section?? for Eg: as part of resource management, I want to create pivots every month and then the fields under the Column will change based on the month. How do I go about it then? I hope my question was clear? looking forward to your reply!
This is definitely too late to help you but I was experiencing the same issue and then after an hour or so of troubleshooting I figured out my issue and it may be yours. In the example he has ThisWorkbook defined as wb. I should have had ActiveWorkbook defined as wb. Too long to explain here but just look up the difference between ActiveWorkbook and ThisWorkBook.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
I absolutely love that you use big data sets in your videos.
Jie this was absolutely fantastic! SOOOOO helpful, I learned a ton!
great stuff - been teaching myself vba over the past year and couldn't find a decent video on pivot tables until yours. subscribed.
Thanks for subscribing. And glad my video helped.
Thank God, I found this tutorial, thanks man you really did a great job
Thank you! I often figure stuff out myself by recording a macro and watching how Excel builds it. Unfortunately, I kept getting errors using the ws.PivotTables.Add method that macro used. This tutorial helped a lot! Thank you!
Super useful!! thanks!
subed man realy insightfull.
Hi - this training is EXCELLENT.
I'm trying to have my vba create a pivot in the nearest blank cell, could you please help?
Hi Jie,
Thanks for your video! I managed to replicate your procedure and get a nice pivot table!
I wonder if it is possible to create multiple pivot tables for specific combinations of variables appearing one after the other (vertically) in the same sheet. For example using a list box where user can select one variable from a table (say Var1) and another listbox where user can select multiple variables from the same table (Var2, Var3, ...). Then creating a pivot table for each combination of those variables, where the single selected Var1 is always displayed on columns and the others horizontally. This will need to account for the size of every table so they dont overlap. I thought this may be a recurrent task but can't find any ressources out there.
Thanks in advance!
You can, but this is something pretty advanced, I won't be able to help in a comment unfortunately.
@@jiejenn Thanks for your reply Jie!
It's great thank you
when creating PTCache, run-time error '440' appears:
Automation error
Hi Jie,
That was some great stuff that you posted. thank you.
I have a question though- is it possible to give dynamic fields in the Pivot under columns section??
for Eg: as part of resource management, I want to create pivots every month and then the fields under the Column will change based on the month.
How do I go about it then?
I hope my question was clear?
looking forward to your reply!
You can, but the additional of code required is gonna be messy though.
I have a question from step 3, what is the purpose of "Sales Report XYZ"?
Using Excel 2013:
I am getting Error:Subscript out of range. Even though variables are declared.
Any ideas? Thanks for the video.
This is definitely too late to help you but I was experiencing the same issue and then after an hour or so of troubleshooting I figured out my issue and it may be yours. In the example he has ThisWorkbook defined as wb. I should have had ActiveWorkbook defined as wb. Too long to explain here but just look up the difference between ActiveWorkbook and ThisWorkBook.
Hi,
How can you get font colour red in VBA editor instead of black. Can anyone please help me to this?
I'm getting label not defined after step 3.
One of your object reference is probably not the right object.
I keep getting Run-Time error "13": anyone got any ideas?