Search results

Wa alaykumu s-salam! Haas. Thank you once again for bringing up such an interesting problem. After going through the workbook attached, I found there are two requirements. Fulfilling these requirements was challenging; however, it was fascinating indeed. Requirement 1: You wanted to calculate...

Dear Mathi, You are absolutely correct. As you have added a new category for status, in this case, "IN PROCESS", you must modify the previous formula. Do not worry, and I have developed a formula that will work for your dataset. Follow the instruction to solve the problem. Steps: Choose cell...

Hello Haas, I truly appreciate your kind words. It's lovely that the VBA script I provided was clear and understandable. I went through your newly attached workbook. The problem seems to be interesting. It will take several hours to think about and implement the algorithm into a VBA...

Wa alaykumu s-salam Brother Haas, I hope this message finds you in the best of health and spirits. I am delighted to hear that my solution was effective and met your expectations. Your kind words and prayers mean a lot to me and my family. May Allah SWT accept your prayers and bless you...

Dear Mathi It is great to see you again. Thanks for posting your requirement with such clarity. You asked for an Excel Formula that will display "IN PROCESS" when A7 (Date Value) is empty, and G7 (Status) is the latest. In contrast, it will show "UR" for a non-empty date value. I have...

Dear Haas Thank you once again for staying with ExcelDemy Forum. Your appreciation means a lot to us. I forgot to provide you with the functionality that will ignore empty cells within the previous code. I am delighted to inform you that I have implemented the feature that will ignore blank...

Hello Jeff33770 Welcome to ExcelDemy Forum! We thank you for posting your query with such clarity. You want to copy rows from one sheet to columns on another sheet. In this case, you can use the TRANSPOSE function in Excel. Assume you have a dataset consisting of four columns titled Name, Age...

Hello Haas Thanks for reaching out and posting such an interesting problem. After investigating the workbook, I understand you want a VBA macro or formulas to solve your issue. I will introduce you to a sub-procedures named CompareAndCopy. The sub-procedure will compare values between two...

Dear Mfaisal Thanks once again for posting your query with such clarity. After investigating the issues you described, I found that you want to remove a link from a workbook without manually opening the workbook. While removing all links, you want to keep previously returned data from those...

Hello Mfaisal Thanks for reaching out. The second issue you describe seems to be a part of another problem. Well, your mentioned second issue may occur for several reasons. I am recommended to check both the source and destination file locations. Ensure the files are in locations which can be...

Dear Condacumar Sorry for the late reply. Thanks for reaching out and posting your issues. You have requested us to prepare an Income Statement from a Trial Balance. To better understand, you also have attached a workbook. We have to create an Income Statement using the values mentioned in...

Dear Bigme, Thank you so much for your kind words! I'm thrilled you found the information shared in the thread very helpful. Your appreciation truly means a lot to me. Best regards, Lutfor Rahman Shimanto

Hi Bigme, My previous modified code has a limitation. To be more specific, there is no column header in ListBox. To get the output you have shown, I have implemented three sub-procedures named ShowList, FilterAndCopyData and DeleteSheetTemp. All you need is to paste these in module1. Later...

Hello Bigme, Thanks for your query. You want to show a list of two columns. I can give a modified version of my previous code. That will fulfil your goal. All you need is to replace the UserForm initialize event with the following code. Sub UserForm_Initialize() Dim ws As Worksheet...

Hello Bigme Thank you for posting an exciting problem. To achieve your requirement, you must insert a UserForm and a ListBox. However, I add some extra features to decorate the UserForm you may like. Steps: Consider a dataset >> insert a button. Open the VBA editor >> insert a UserForm...

You are most welcome, Amit! Feel free to reach out again with some other exciting problem of yours. Regards Lutfor Rahman Shimanto

Dear Amit Good afternoon! I am happy to inform you that I succeeded in reaching your requirements. I modified the previous code and applied extra features and tools to overcome the mentioned limitations. To be specific, I have developed two UserForms. Excel VBA Procedure: Public...

Dear Amit I definitely have to praise your observations. Absolutely, the previous code contains the limitations you have mentioned. Modifying the code I provided will take some hours to reach your goal. When I am done, I will share the solution in this thread. Thank you, once again, for...

Hello Kescoworksamit Thanks for reaching out and posting your queries with such clarity. I am delighted to inform you that I have developed such a macro that full-fill your requirements. I have tested the macro several times within your provided workbooks. I found almost the same output as you...

Dear Francilla I am incredibly sorry that the formula I previously provided contains a mistake. I noticed that mistake when I started to break down the formula for you. I mistakenly used total frequency as f. However, I am all aware now. I have developed an Excel Formula derived from the...