Recent content by Lutfor Rahman Shimanto

Hello Bradbu Thanks for sharing such an exciting problem. I have reviewed the problem and your attached file and found that using an Excel VBA event procedure will suit your situation. Please check the following: Follow these steps: Right-click on the sheet name. Click on View Code. Paste...

Dear Lisa Gordon Thanks for your kind words! You are welcome. We are glad it worked on your end. Adding and removing rows will affect the formulas. However, suppose you add and remove rows between the ranges instead of adding and removing them at the end or beginning of the range. In that...

Dear Willem Witwerts, you are very welcome. Don't hesitate to reach out again for further queries. Regards ExcelDemy

Hello Willem Witwerts Welcome to ExcelDemy Forum! Thanks for sharing your file and explaining the problem with such clarity. I have reviewed your Excel file. I did not find any unintended changes. However, I have applied Increase Decimal within the BWT field and uncommented some blocks of...

Dear GEO Thanks for your kind words! You are very welcome. Your appreciation means a lot to us. Regards ExcelDemy

Dear Geo It's great to see you again. I have reviewed your problem and improved the formula to fulfil your requirements. Please check the following: Improved Excel Formula: Hopefully, you have found the solution you were looking for. I have attached the solution workbook as well. Stay...

Dear Brandy Thanks for your compliments! You are very welcome. YES, absolutely. Don't hesitate to reach out again with further queries. Regards ExcelDemy

Hello Brandy Thanks for your wonderful compliment! Your appreciation means a lot to us. I am delighted to inform you that I have reviewed your problem and found a solution for you. Please check the following: Error 13 Type Mismatch in VBA typically occurs when you try to perform an...

Dear Sharad Thanks for your nice words. Your appreciation means a lot to us. I have reviewed your requirements and improved the previously given Excel VBA Sub-procedure. All you need to do is to keep the attachment addresses by putting a comma within these attachments, like the following...

Hello Sharad Thanks for reaching out and sharing your problem. I have reviewed your situation and come up with a tricky idea. All you need to do is display the emails before adding the HTML body and sending them. Don't worry! I have improved the existing code to fulfil your goal. So, please...

Dear Gary Thornton Thanks for your nice words! You are always welcome. Yes! You are correct. All you need to do is to save your file in the intended format. We look forward to seeing you again. Good luck. Regards Lutfor Rahman Shimanto ExcelDemy

Hello Agongpor Welcome to ExcelDemy Forum! Thanks for your time and for sharing your expertise within the ExcelDemy community. Though simple, we hope this template will reduce Sanjfer's difficulties. We thank you both (Agongpor & Sanjfer) for contributing to the ExcelDemy Forum. Regards ExcelDemy

Thank you for your kind words! It means a lot to us. You're very welcome, Jululian! We are glad to hear the VBA solution worked well for you. Regards ExcelDemy

Dear Jululian Thanks for sharing your requirements. I reviewed your problem and found that developing such formulas using only Excel's built-in function is extremely difficult and time-consuming. So, I have created an Excel VBA User-defined function to fulfil your goal. Later, use the TRANSPOSE...

Dear Gary Thornton Thanks for sharing your problem with a dataset. It helped me understand the date data structure you are using. I am delighted to inform you that I have reviewed your problem and developed a complex formula using IF, OR, MONTH, DATEVALUE, LEFT, MID, and FIND functions...