Hi Chester, if you copy and paste this spreadsheet and you change the data on the table, say weekly or monthly, does the code you put in automatically update the pivot table or does it pick up the original cache?
Text values in value field gets converted to number.. But i want it to remain as text... I have recorded it by adding data model and using ConcateneX but this doesn't work for other sheets. Please tell me the code to add datamodel and give text in value filed.
what if I wanted to add the pivot table to a separate workbook
Nice video. Easy to understand sir.
NICE video But if I have to add 2 values in One Row Field Then what we do
Hi Chester, if you copy and paste this spreadsheet and you change the data on the table, say weekly or monthly, does the code you put in automatically update the pivot table or does it pick up the original cache?
Thank you so much ❣️❣️❣️
Thank you so much sir 😌😌😌
Can you also show how to add a pivot chart to this same pivot table?
Thank you sooo much!
Very useful video to us., but in the code "with PT" throwing an error like variable not set. Could you help me please
Hi
Thanks a lot for the great video, could you explain what Is the purpose of (.orientation =xLRowField, xLColumnField, xLDataField)
Thanks
Text values in value field gets converted to number.. But i want it to remain as text... I have recorded it by adding data model and using ConcateneX but this doesn't work for other sheets.
Please tell me the code to add datamodel and give text in value filed.
Please Update this Both Videos..
How to Extract Month Name from Data Of overall Data of Large siza
How to add filter to the page filter with vba
I can't see off the edge of the screen
PLEASE Update This Video
How To Extract Month name From Overall Data of large Size