Forum

Hi David, Open the workbook. Open the VBA editor (ALT+F11) Open the code module for the sheet (double click it) Select all the code, then ...

Hi David, Workbook Event code needs to be in the ThisWorkbook module, not in a separate code module. Move your code into the ThisWorkbook module- ...

Hi Katerina, If you get stuck just let us know. Regards Phil

Hi Bruno, You can put the file onto OneDrive, Google Drive or DropBox then email me a link to download it. Or email the file to me Phil

You're welcome Al 🙂

Hi Marsil, You insert in where I said to insert it in Reply #2 above. Insert it after Set objOutlookMsg = objOutlook.CreateItem(0) See attach...

Thanks for letting us know. Phil

Hi Al, Attached is a file that creates a PDF report and it emails to the relevant people based on the company names and emails on the Reporting Con...

Hi Bill, How do you know the count is wrong? Can you please share the Excel workbook and the source data file(s) so I can check. Thanks Ph...

Hi Akira, Yes you can email it to us on that address. Regards Phil

Hi Kenneth, Can you please attach your actual workbook otherwise any code we write will need to be modified to suit your real workbook environment....

Hi Bruno, The way you have implemented the function isn't the way I did it in the example file I provided. Rather than Add Column -> Invoke C...

Hi Bill, When your data is ready click on Close & Load in the top left of the query editor. NOTE click on the text Close & Load, not the ic...

Hi Uma, I've never done this with VBA, or even know if it can be done. But you could implement it with with Power Query although it isn't a trivia...

Hi Al, Implementing Step 4 isn't too difficult but I'm not sure who the emails should be sent to. For example, if the PT filter on Consolidate T...