Search results

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

Dear, No problem! We are always here to assist. Thanks for your kind words. Your appreciation means a lot to us. Regards Lutfor Rahman Shimanto ExcelDemy

Dear, Thanks for your query! I have reviewed your dataset and found that merged cells exist. So, if you use an array formula to populate the intended values, you might get a #SPILL! Error. Moreover, developing such formulas would be very time-consuming. So, I recommend you use the previously...

Dear Jululian It is good to see you again. Thanks for your nice words. I have reviewed your requirements, which are described in the attached Excel file. Though it seems like a day-killer problem, I am able to solve it somehow with the help of a helper column (within this range, the text font...

Dear, Thanks for your patience! I have reviewed the problem you mentioned. You are right! The reason behind this is that you may have missed making proper cell references for JESSICA HUDSON. When you apply the formulas for a new instructor, you must adjust the formulas. Please check the...

Dear Roktobondhu Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem. You are facing difficulties with an INDEX-MATCH formula. You mentioned that it works on your mobile device but not your PC, which uses Excel 2016. I have reviewed your formula and found that it is...