Forum

Hi Rajsha, the code will work with any file type. Just specify the URL for the file in Col A. Are you trying to say that you want to get any/al...

Ahh, you're using a Mac 🙁 Can't use this method to send email on a Mac I'm afraid. Mac's do not support this. I do not have a Mac nor have I eve...

Hi Rajsha, The attached workbook does what you ask. You only need to specify the save folder once in cell C2 - change this to suit your PC. I...

No worries Andy. That code works fine for me but I'm running it out of the context of your environment. So I'll need your workbook to test it prop...

Yes, merged cells are evil!

Hi Alec, Please supply your workbook, hard to debug this without your data. Phil

Hi Rajsha, Please supply your workbook with code. Regards Phil

No worries Rob. I don't have a Mac so that makes it interesting. It does appear that Mac's do not support Application.FileDialog which is being us...

Hi Rob, DV = Data Validation = Drop Down. These are the lists you wanted to use to load different investors details into the sheet before creating...

no worries. 🙂

Hi Rose, At the start page for each course there's a link to download any associated course files, e.g. for Power BI you'll see this link Regard...

Hi Rob, You don't have any DV lists set up. In the code I sent you, and in the image posted above, the cell using the DV List is B6. In the cod...

Hi Bruno, Sounds like a job for a pivot table. Please supply your workbook with the data. Regards Phil

Hi Jay, You need to wrap the 2 x COUNTIFS in an OR because you want to check both forwards or backwards in time for another Buy =IF(AND(I7<0,...

Hi Rob, That's an XLSX file so there's no VBA in it. You'll need to save the file as a .XLSM. Phil