Forum

Hi, I'm not clear on what it is you actually want to do. That VBA code does what it is intended to do which is tell you if there are blank cells...

No worries.

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

No worries 🙂

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