Last seen: Jun 7, 2026
Hi Doug, Can you please supply your workbooks so we don't have to recreate everything. The IF in your 2nd image doesn't have any logical test? ...
Thanks Dennis. I've modified the function to reset in October - see attached. Regards Phil
Hi Shardul, Excel will display dates in whatever your regional settings define. So if your regional settings use m/d/y then that is what you are g...
Hi Guy, There's no image attached. Have you read these blog posts : Getting Started with API's in Power Query Connecting to an OAuth API ...
Hi Dennis, Please see attached file. This works out the monthly change based on the Account Number and the Customer. I'm not sure that Row 20 i...
no worries.
Hi Keivan See attached file for solution. As I don't have access to your source file I copied the data in the sheet into another table and creat...
Hi David, This actually creates a 2 dimensional array- the quirks of VBA! To access the contents you need Debug.Print ArrayMortality(i, 1) ...
Hi David, I just ran it on my W10 Office 64 bit PC?? So, you still haven't said what problem you are experiencing. When you try to run the macr...
Hi Hannu, When the search returned nothing, a pop-up was created in the Chrome browser - didn't you see this? Because your code was looking for ...
Hi Martin, I'm not sure there is an equivalent in PQ to a Global Temp Table, and I'm not sure how you intend to make use of one. If you create a...
no worries 🙂
Hi Omar, So you want to send each sheet to a different email address? You can't reliably set up Excel to auto-send at specific periods. For a s...