Forum

Hi Rob, Attached is a workbook with code that does the job. However, you'll need to incorporate it into your own workbook. As it is it's not usin...

Hi Jay, There's no information on your workbook about when/if a security has been bought or sold in the 30 days before or after any particular tran...

Hi Rajsha, You can contact me via this forum. Regards Phil

Hi Janai, Please attach your workbook so I can see the data. Regards Phil

This is the one

Hi Rajsha, OK, not sure why you don't have access to Selenium or Python, they are both free. As I'm not familiar with your environment or the rest...

Hi Amit, Without being at the PC in question hard to say. You say the code works on another machine so the issue isn't the code. Things I'd che...

Hi Rajsha, Never done this with VBA, I have to wonder why you are using Excel to do this? Doesn't seem the like the best tool. You could try us...

Hi Nishit, Please see attached workbook for working solution. Couple of things. In the code you sent, you are referencing a control called txtD...

Hi, Do you mean 70-778? Can't say any more than make sure you study everything you can and practice a lot. Do a lot of practical work. Can't h...

Hi Amit, The code in the workbook and the code in your image are not the same. I can run the code in the workbook you attached without issue. A...

Hi Alain, You can do this with a combination of INDEX, SUMPRODUCT and SEARCH. There's a blog post on how it works here Search a String for a Li...

Hi Robert, The link is at the top of the Grouping sheet in the workbook that comes with the course. Here's the link Regards Phil

Hi Maurizio, I've written some code to do what you want but it may need to be more robust as it checks for the occurrence of a string e.g. Blu with...

No worries 🙂