hi I have uploaded a file, can you please share how to group the data in pivot table like below, 0-100 101-200 201-300 etc... many ...
Hi Phil I guess that I was afraid of getting out of my comfort zone... I have started using PQ since 2018, but a lot of my old reports were built t...
Hi Phil The query is linked to work database, I am not sure if I can share here. I can get to 'choose data source' window, but the query goes bl...
Hi Mynda If any user does not have the access to certain database, it seems like he can't refresh the query. Is there any better way to refresh...
Thank you so much for your help, Phil! I will have a look the query and function and learn from there. Does it exclude the weekends as well? Wha...
I have updated the code as you suggested, Sub SendEmail() Set olApp = CreateObject("Outlook.application") Set objMail = olApp.CreateItem(olMail...
thank you very much!
Thanks! If I only want to copy visible cells on sheet “Export”, how can I change the code? Because the data I want to copy is filtered on sheet “Expor...