Search results

Hello Gredang Thanks for reaching out and posting your queries within the ExcelDemy Forum. You have two worksheets called Names and Data. In sheet Data, you have a list of data which consists of Names, Email Addresses, Contact No, and Residential Addresses. In sheet Names, you have ten rows of...

Thanks for thanking me, Mathi. You're very most welcome. Don't hesitate to contact us with further questions or assistance. Regards Lutfor Rahman Shimanto

Hello Mathi Thanks for reaching out and sharing your difficulties with ExcelDemy Forum. By analyzing your problem, we understand that you need help with a formula to generate the final result. We can solve the issue by forming a complex formula. I developed the formula by combining the IF...

Excel VBA Code (UserForm1): Private Sub CommandButton1_Click() Dim ws As Worksheet Dim wsCaseNo As Worksheet Dim wsDate As Worksheet Dim wsCredit As Worksheet Dim wsBalance As Worksheet Dim wsRemarks As Worksheet Dim lastRow, lastRowSummary As Long Set ws...

Dear Marudhu1973 I hope this post will find you well. As per request, I have implemented the model mentioned below. You wanted a Data Entry form that will append data in individual sheets. I have implemented it as you wanted. In my view, that is not necessary at this stage. Also, you did not...

Hello Marudhu1973 Thanks for reaching out and posting your query. The requirement you mentioned can easily be solved with Excel VBA's help. Currently, I am designing the Data Entry form. Later, I have to start the coding part. However, implementing the Data Entry form and Report will take...

Dear Anuragv, You're very most welcome! I'm glad to hear the VBA code worked for you. We are always happy to help, and it makes us happy that we can make your life easier. Getting such a touching thankfulness inspires us to keep helping people. Don't hesitate to contact us with further...

Dear Mfaisal Thanks a ton for staying with us. As per request, I am introducing an Excel VBA sub-procedure called SelectFilesAndCopyToMasterSheetAdvanced. This time, the procedure calls a User-defined function named GetMonthNumber. Excel VBA Code: Function GetMonthNumber(monthAbbreviation As...

Dear Mfaisal Thanks for your question about the previous code. Multiple files may have the same modified dates. In this case, the code copies according to the serial as it appears in the folder after sorting by modified dates. However, you are requesting to implement a procedure that will...

Dear Maps You're most welcome! It was my pleasure to assist you. Sometimes, our challenges can be complex, and finding the perfect solution can be challenging. Indeed, the challenges can be made more accessible by utilizing Excel VBA. Please don't hesitate to reach out again if you have...

Dear Mfaisal Thanks for reaching out and posting your problem. After reading the thread, I understand you have specific files in a folder. You collect certain data from each file into a Master file. You need a procedure to copy data from all files. And you want not only to copy data but also to...

Hello Mfaisal Thanks for reaching out and posting your issue. In VBScript, you cannot directly define a static range of values like an array using the range object. The range object in VBScript is typically used to represent a cell or a range of cells in an Excel worksheet. If you want to...

Hello Maps Thank you once again for explaining more about the problem. I still needed help understanding embedding new lines. Anyway, I understand the first issue in range L17:M17 of SourceData goes to L12:M12 in the Summary sheet using a formula. Likewise, the second issue in D23:E23 of...

Thank you for explaining your issue with such clarity, Zeke. After exploring this thread, I understand that you want to get the information produced in the W column and transfer back the values in the V column for the next cycle. Specifically, the remaining amount must be the initial amount for...

Dear Maps Again, Thank you for reaching out and explaining the issue with clarity. You want to pick the information from the SourceData sheet where gas is issued and avoid the line with no gas issues. In the Summary sheet, you have written the expected result. As requested, I have developed a...

Thank you for explaining your problem with such clarity, Hayley! Since the code I provided contains only a User-defined function, the VBE shows you that window asking for a macro name. We can call a UDF from a cell or a sub-procedure. Key Steps: Press Alt+F11 to open the VBE. Navigate the...

Hello Hayley Thanks for reaching out and posting your issue. You are correct that there is no Logistic option in the Format Trendline pane, so you must create a custom Trendline that closely resembles the Logistic Trendline option in Excel. You can achieve this by using a user-defined function...

Hello Maps Thanks for reaching out and posting the exciting issue. Exploring the problem you mentioned, I understand you need help with an Excel formula to show details of vehicles that were issued with Gas. As you requested, I can assist you with a complex formula and implement that with the...

Dear Anuragv Thanks for reaching out and posting your query on this platform. After investigating the issue you mentioned, I understand that you want a formula or VBA macro to scan both spreadsheets with blank Invoice no or Dispatch date columns, and if the condition is true, copy all the...

Hello Anuragv, The issue you are addressing can be solved using the VLOOKUP, IF and ISBLANK functions. However, Excel VBA provides us with a prominent solution regarding your issue. Regards