Hi Ajay, just awesome explanation on the pivots, I've a question, I've created a dynamic pivot (where the data range always change) with the help of your video and ofcourse with the help of macro editor,haha, thanks for showing that one as well. So my question is, the macro is working perfectly fine but one issue, there is row and column named as "(blank)" is getting inserted automatically and my user has to delete it every time he runs the macro. And since the number of rows and columns are dynamic in my data I'm unable to automatically delete them, for example, the row and column named (blank) which is getting inserted automatically will be sometimes at C column and 20th row and sometimes F column and 500th row, hope you understood what I'm trying to explain, so could you please help me in fixing the issue, this will be a great learning and help for me, many thanks in advance!!! P.S :- when I searched on Google and went through many RUclips videos to find the reason behind the blank row and column getting inserted is if one cell in the Range is empty then this will happen in my case it is true, I've some empty cells in my data range.
Sir i am working on excel & wanted complete excel . Give the on advance excel from biggner to advance level pivot, vba, macro... I have watch this video & much satisfied & love it... Thanks... Keep it up
Hello, I don't understand "Why did you declare the variables ?". In your code - Dim pt as PivotTable""and "Dim ptcs as PivotCache".. it's not use any where. Why did you declare then ?
Hi Ajay sir, i created pivot table for a report which is working nicely but when I tried to do the same for another report pivot cache is not working only. The code is running but pivot table is not creating. Code is only working till ranges which I specified right before pictures cache
sir this is not working for a some database.. in those cases blank pivot table is not creating.. I'm unable to diagnose the bug where it is.. everything is okk for all.. but sometimes it doesn't execute the command (i.e - activeworkbook.pivotcache.create(...) Please look into this🙏
hi sir....Please resolve my doubt Can we run 3 VBA Macros in one workbook which are downloading the attachments from outlook, data consolidation of multiple attachments and Pivot table of Consolidated file. Please let me know.
Sir, thank you for the video but it is not working on my excel data. The code is not creating blank pivot and I am not able to figure out where the issue is..
Helo Ajayji my big Bro mere bhai yeh vedio sab parliya, yaad karliyah , it works up to range A1:Z100 but It does not work range like A1:AB39... why..???? how do I take such range... Mei apani company ka ek excel sheet send karungga appkay email mai if u do not beleive me... your video 266 really works but not to the range that exceed "z" & when the range comes to "AA"... For God sake please help me lol !!!!!
It works but it doesn't work in a large data range A1:AJ33 , I ve practice n done several times in a small table range it works but in a big Table I dont know how it always failed. Please Help !!! Sir appke wow table A1:C5 in the video, kabhi same table may jada wala range aanay say for example A1:C5 ke badalay upto C10 honay say kon sa Code dalayga,,, what I want is jo source hena usska range na likhnay say coding may to koi yee bhi different range of same table Pivot banana possible hoga
Bro why did you take Dim when you are not going to use it ? Your way of explaining is good but doesn't solve the purpose. Make the table dynamic and add a button which will automatically update the source_field and refreshes the pivot table at the same time.
Hello Sir, how to create a dynamic pivot, which can auto refresh when there is a change in the table?
Hi Ajay, just awesome explanation on the pivots, I've a question, I've created a dynamic pivot (where the data range always change) with the help of your video and ofcourse with the help of macro editor,haha, thanks for showing that one as well. So my question is, the macro is working perfectly fine but one issue, there is row and column named as "(blank)" is getting inserted automatically and my user has to delete it every time he runs the macro. And since the number of rows and columns are dynamic in my data I'm unable to automatically delete them, for example, the row and column named (blank) which is getting inserted automatically will be sometimes at C column and 20th row and sometimes F column and 500th row, hope you understood what I'm trying to explain, so could you please help me in fixing the issue, this will be a great learning and help for me, many thanks in advance!!!
P.S :- when I searched on Google and went through many RUclips videos to find the reason behind the blank row and column getting inserted is if one cell in the Range is empty then this will happen in my case it is true, I've some empty cells in my data range.
Sir i am working on excel & wanted complete excel . Give the on advance excel from biggner to advance level pivot, vba, macro... I have watch this video & much satisfied & love it... Thanks... Keep it up
Go to my website
One of the best n easy video to do pivot table in vba. How can we filter data, which is kept in filter field.
Simple awesome Ajay sir thank u so much...
Thanks Rakesh..
Awesome sir
Best video
Have a generic query. How to modify msgbox dimensions in vba ?
Hello, I don't understand "Why did you declare the variables ?". In your code - Dim pt as PivotTable""and "Dim ptcs as PivotCache".. it's not use any where. Why did you declare then ?
Hi Ajay sir, i created pivot table for a report which is working nicely but when I tried to do the same for another report pivot cache is not working only. The code is running but pivot table is not creating. Code is only working till ranges which I specified right before pictures cache
Thank You!
sir this is not working for a some database.. in those cases blank pivot table is not creating.. I'm unable to diagnose the bug where it is.. everything is okk for all.. but sometimes it doesn't execute the command (i.e - activeworkbook.pivotcache.create(...)
Please look into this🙏
thx buddy u r awesome
Thanks Lalit..
Thank you so much sir...It is a awesome video
hi sir....Please resolve my doubt
Can we run 3 VBA Macros in one workbook which are downloading the attachments from outlook, data consolidation of multiple attachments and Pivot table of Consolidated file. Please let me know.
Use call keyword
Hi Sir,
If my data is in sheet 1 and want to create pivot in sheet2. What will be the code.... This code not working
Hi do you have any other video for pivot table vba
For dynamic range Range("A1"). current region.address work for me 😀
Sir, thank you for the video but it is not working on my excel data. The code is not creating blank pivot and I am not able to figure out where the issue is..
Please share error description and line that throw error
Sir please can you make a basic detailed video in Hindi
👍
Helo Ajayji my big Bro mere bhai yeh vedio sab parliya, yaad karliyah , it works up to range A1:Z100 but It does not work range like A1:AB39... why..???? how do I take such range... Mei apani company ka ek excel sheet send karungga appkay email mai if u do not beleive me... your video 266 really works but not to the range that exceed "z" & when the range comes to "AA"... For God sake please help me lol !!!!!
It works but it doesn't work in a large data range A1:AJ33 , I ve practice n done several times in a small table range it works but in a big Table I dont know how it always failed. Please Help !!!
Sir appke wow table A1:C5 in the video, kabhi same table may jada wala range aanay say for example A1:C5 ke badalay upto C10 honay say kon sa Code dalayga,,, what I want is jo source hena usska range na likhnay say coding may to koi yee bhi different range of same table Pivot banana possible hoga
I am facing the same issue.
Ajay can you please help with this , please!!!
Bro why did you take Dim when you are not going to use it ? Your way of explaining is good but doesn't solve the purpose. Make the table dynamic and add a button which will automatically update the source_field and refreshes the pivot table at the same time.