Forum

Hi Catalin, Thanks for the recommendation.I will do a research for all the excel courses including this website. Yes there is no relationship be...

Hi Catalin, Yes i see VBA is abit complicated than Power Query. I have programming background and currently dealing with asp.net and vba project...

Hi Catalin, Wow,the code is really awesome! I learned something new from you 🙂 Thank you! Do you have any vba course available that can learn f...

Hi Catalin, Sorry that i keep try and try but also no success, really need your help 🙁 I moved the code from normal module to the sheet2 (pivot...

Hi Catalin, I tried to use your code, but when i try to debug,it doesn't fire the Worksheet_PivotTableUpdate event? Not able to step into the code ...

Hi Catalin, Thanks for the feedback. I am able to create a button to sort the top 10.Now stuck on the unfilter issue. But the quarter selecte...

Hi Catalin, Yes it is more simple to do with macro, but what if to clear the filter of top 10? I would like to do like which have the clear filt...

Hi Catalin, I still have a question to ask for your opinion regarding the pivot table, can i do a slicer to sort top 10? I am looking for tutorial ...

Hi Catalin, Ohhh...so stupid me..haha..i am thinking too complicated.Between,its just so simple 😀 Yes you are right, just grab a label only..om...

Hi Catalin, Yes.I know how the absolute and relative reference work. Ok sure i can explain more details on the attachment. The result table is f...

Hi Catalin, Glad to receive your reply again 🙂 The formula you mentioned here is fixed the cell reference without moving.It should be $A8 inste...

Hi Catalin, I am back to here again to seek for your help as i am facing the issue for the GETPIVOTDATA that you teached me last time. Last time...

Hi Sunny, Its ok. Thanks for your effort trying to help me. Appreciate 🙂

Hi Sunny, The field i want to filter is Activity Billing Type on Part Usage Table while Category field on Revenue table. I have to use pivot tab...

Hi Sunny, Thanks for your replied. I think I am mistakenly using wrong formula(index match), because my pivot table once filtered, then the row ...