Forum

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 🙂

Hi Mark, Did you try to create the GPD formula for the 2nd PT manually? You can create a GPD formula by clicking on the cell in the PT that you wa...

Hi Stephen, I can think of more than one way this could be done but without seeing your data I don't know which way is best. Please attach your wo...