Forum

Hi Robb, I journeyed down a few rabbit holes working on this as there are several ways it could be solved. In the end I decided to use some helper...

Hi Steven, Shockwave Flash is old technology and shouldn't be used. Surprised it's still an option you can choose. Regards Phil

Hi Jason, Can you post the file(s) containing the queries, and any necessary source data, so we can have a look. Thanks Phil

Hi Bruno, This is getting very messy and complicated. I've looked at the 3 files you've most recently supplied and unfortunately that just confuse...

Cross posted to here Do not cross post without linking to the cross post to let us know

No worries Pieter 🙂

Hi Pieter, Please see attached file for solution. The result is on Sheet1. Regards Phil

OK, glad to hear it's working now.

Hi Maarten, It should work fine. What exactly are you experiencing? Can you supply a screenshot? Regards Phil

Hi Bruno, That file doesn't have any of my code in it so I can't see what you are doing and fix the problems. I've already supplied instructio...

Hi Mourad, What are you doing with these files? Power Query might be a better solution depending on what you are doing. Phil

Nothing received.

Glad to hear it's working

Hi David, Open the workbook. Open the VBA editor (ALT+F11) Open the code module for the sheet (double click it) Select all the code, then ...

Hi David, Workbook Event code needs to be in the ThisWorkbook module, not in a separate code module. Move your code into the ThisWorkbook module- ...