Beautiful Mynda... been banging my head for days now to get this sorted... finally got it working as i am working on a completely separate sheet and t...
Hi Mynda, I understand, but some strange reason it is fizzling me out, not able to get what you did in the sheet. Attaching the same sheet that ...
Hi Mynda, Just to clarify, I am looking for specific time rows (date will always be current day). So on the given day, at any point in time, I shou...
Thanks Mynda, I believe as before I just glanced at the excel sheet and replied back without checking the queries window. My apologies. I shall ch...
Hello Mynda, I guess I probably failed explaining myself clearly. The rows keep changing throughout the day during the market hours from 9:15 AM...
Thanks mate, appreciate your help. ~GK
Bad luck mate, getting Run Time Error '9'. Subscript out of range. Let me know if this information is enough. I had put your first code by create ...
Thank you Catalin Bombea, will try that today and revert to you. Regards ~GK
Thanks Mynda. This only refreshes the power query but I am looking for the pivot that you had created. Believe VB is the only answer, will creat...
Hi Mynda, The pivot that you created requires auto-refresh. While we have auto-refresh for the query at any specified intervals, to refresh a pivo...
Damn, my bad, Mynda, I was so focused on the excel sheet missed this dearly. My apologies, Mynda. That clears the air, so all is well. Thank ...
Hello Mynda, That saved a lot of time Mynda and not to mention the headache that came with it. So a big thank you for not only resolving but givin...