Search results

  1. Lutfor Rahman Shimanto

    [Solved] Need help creating a formula

    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...
  2. Lutfor Rahman Shimanto

    Problemen met het laden van cellen in userform en terug plaatsen

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

    Problemen met het laden van cellen in userform en terug plaatsen

    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...
  4. Lutfor Rahman Shimanto

    Adding a Second sheet to my Formula

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

    Adding a Second sheet to my Formula

    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...
  6. Lutfor Rahman Shimanto

    [Solved] Creating A Search Box Utilizing VBA Code

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

    [Solved] Creating A Search Box Utilizing VBA Code

    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...
  8. Lutfor Rahman Shimanto

    [Solved] Bulk Email Using VBA and Signature

    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...
  9. Lutfor Rahman Shimanto

    [Solved] Bulk Email Using VBA and Signature

    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...
  10. Lutfor Rahman Shimanto

    [Solved] Formula to Order Product Automatically Once Every Three Months

    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
  11. Lutfor Rahman Shimanto

    [Solved] Excel Template for employee uniform issues

    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
  12. Lutfor Rahman Shimanto

    [Solved] Lookup Table Formula to Insert Subject Names Instead of Numbers

    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
  13. Lutfor Rahman Shimanto

    [Solved] Lookup Table Formula to Insert Subject Names Instead of Numbers

    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...
  14. Lutfor Rahman Shimanto

    [Solved] Formula to Order Product Automatically Once Every Three Months

    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...
  15. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    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
  16. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    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...
  17. Lutfor Rahman Shimanto

    [Solved] Lookup Table Formula to Insert Subject Names Instead of Numbers

    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...
  18. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    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...
  19. Lutfor Rahman Shimanto

    [Solved] INDEX+MATCH

    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...
  20. Lutfor Rahman Shimanto

    [Solved] Highlighting Non-Unique Number Patterns in Multiple Columns

    Dear Artkitthana Welcome to ExcelDemy Forum! Thanks for sharing your problem with such clarity. I have reviewed your requirements and improved the existing sub-procedure to fulfil your goal. Please check the following: Improved Excel VBA Sub-procedure: Sub Test0() Dim rall As Range, r...

Online statistics

Members online
1
Guests online
9
Total visitors
10

Forum statistics

Threads
318
Messages
1,408
Members
583
Latest member
mibr fan token
Top