Last seen: Jun 10, 2026
Hi Leah, Please see attached workbook. As it is each email will be displayed on your screen for you to check it is correct. This is just for yo...
Hi, See the attached workbook. There's a new Sub called FormatSeries. Regards Phil
Please attach your workbooks
Hi Sean, Please post the latest workbook with your formula that is generating the #REF Regards Phil
Hi Lajos, After working on this I think it'll become very complicated to do exactly what you have asked for. You say that you want 3 emails, 1 of ...
Hi Azatat, Without your workbook and data it's a bit hard to know that I'm working on this correctly, but I think all you need is an IF AND formula...
Hi HR, There's no attachment in your last post. Regards Phil
Hi Lajos, Yes this can be done. However, if I write code now based on the sample data you entered above which I have to copy into a new workbook, t...
Hi, I don't know the exact format of your text files but you could merge them all from Terminal then just import 1 file? Place all the text file...
Hi AM, Not sure why you are getting #REF without seeing what is causing that error. If you have XLOOKUP you can use 2 nested XLOOKUP's - see att...
Hi Lea, Do you want to send them a copy of the sheet? Or send them a PDF? Or an image? Will each person get the same report? I'm not sure w...
Hi Steve, If you are reading the filename from a cell, why do you need to display a dialog box asking for the filename? I'd just check if the ce...
Hi Gabriel, Similar problem. You have 2 bits of code setting the reg date. In this sub your setting it to CValue after you'd set it to the dat...