Forum

Hi Rob, No worries, can you supply your workbook please, it's difficult to debug without the actual code. regards Phil

Yeah sorry, I meant COUNTIFS! I've adjusted my reply.

Hi Jay, You can use COUNTIFS to check the conditions (Loss and within 30 days). =IF(AND(I7<0,COUNTIFS(B$3:$B6, ">="&B7-30,$A$3:A6, "...

and this post is specifically about Pivot Charts P

But how do I know what shares were bought when? I don't see where the actual share is identified. Are you buying/selling the same share (company) in...

Hi Sholtan, This sounds like homework. Have you tried to solve it yourself? Please attach your attempt and I'll be happy to guide you. Regards...

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...