Forum

Hi Flor, You initial qs just said you were trying to look up one email address in another list on a separate sheet. How exactly does country play ...

Hi Alberto, You can add a Conditional Column and specify 0 for null and 1 for not null: then delete the date column. Regards Phil

Hi Flor, I don't fully understand what it is you are trying to achieve. But it looks like you're trying to check if an email exists in a column? ...

Hi mm, Thanks for the workbook but it's an XLSX so we'd still need to copy/paste your code from the forum into it to test it out 🙂 Please supply ...

Thanks Maurizio. Try the attached file. You will need to enter your own GMail email/password of course. Regards Phil

Hi Peter, You just need to wrap the HYPERLINKS in IFERROR because mousing over the link will generate an error. =IFERROR(HYPERLINK(dostuff(), "D...

Sholtan, I can't figure out what files are for input,which ones are for output. You've shown an image of 'correct output' but which file is this...

Sholtan, Please attach the workbook with the VBA in it. Even if you paste code we have to copy it, create a workbook, paste it in, save it etc etc...

Hi Janai, The code you've supplied doesn't seem to tie in with the data you provided e.g. the code refers to Range("C10"), Range("D10") and Range("...

Hi Maurizio, You can use Application.FileDialog(msoFileDialogFilePicker) to let the user choose the attachment. I've unmerged the cells on the s...

no worries Maurizio.

Between us we came up with 5 solutions. Pretty good. 🙂

Hi Stephen, Welcome aboard. Have you tried a pivot chart? Please supply your workbook and data. regards Phil

Hi Vinod, It's possible to install multiple versions of Office together, at least it used to be, but I've not done it with 2019. You can get iss...