Search results

Hello BigMe Thanks for sharing your problem. I want to sum up multiple dynamic ranges. Assuming the row of each range may vary from time to time. I am presenting an Excel VBA Event Procedure that will trigger when any values change with column B. Follow these steps: Step 1: Right-click on the...

Dear Koolrk Thanks for your nice words. Your appreciation means a lot to us. You are always welcome to the ExcelDemy Forum. Stay blessed. Regards Lutfor Rahman Shimanto ExcelDemy

Hello Suresh Gilda Welcome to ExcelDemy Forum. I am delighted to inform you I have fulfilled the requirements you describe within the workbook. The requirements are achieved by developing many complex Excel Formulas and Conditional Formatting. Besides, I reorganized your sheet structure to...

Dear Nikhil Patki You probably worked on modifying the first sub-procedure I developed earlier (before sharing your dataset) based on a dataset I created to demonstrate your problem. After sharing your dataset, I have modified the sub-procedure that is currently working for your dataset...

Hello Nikhil Patki You are welcome. Your appreciation means a lot to us. We are always here for your Excel & VBA-related queries and many more. According to your dataset, I have developed an Event Procedure and a Sub-procedure. I am glad to hear that it is working fine for your dataset...

Dear Nikhil Patki Thanks for sharing your dataset. I have modified my previous code in such a way that you can use it in your workbook. Likewise, paste the following code into the sheet (Data) module and save the workbook. Sub-procedure & Event Procedure: Private Sub Worksheet_Change(ByVal...

Hello Nikhil Patki Welcome to ExcelDemy Form. Thanks for reaching out and sharing your problem. You said you have a Macro that applies an advanced filter, but after changing the criteria and refreshing, the macro only refreshes the first column. You have to clear the contents of the previous...

Hello Ashish29 Thanks for your well-layout explanation. On our end, we are getting the desired result. We are using Microsoft Excel 365. Another suggestion: I have found the AT (@) sign after the Equal (=) sign in your formula, which means you are using a formula that is unavailable in the...

Hello Asalhaljayar Welcome to ExcelDemy Forum. Thanks for reaching out and posting your question. You want to create an email form to be filled out dynamically by a macro for the current month. I am delighted to inform you that I have developed an Excel VBA sub-procedure to fulfil your...

Hello Adamiou88 Thanks for thanking me. Welcome to ExcelDemy Forum.

Hello Koolrk Welcome to ExcelDemy Forum. Thanks for reaching out and posting your problem. Based on three parameters, you wanted to fetch the VM% values from Sheet1 to the VM% sheet. The parameters are Source, P.O NUMBER and IG_DATE. I am delighted to inform you that I have developed an Excel...

You are most welcome, Mfaisal.

Dear MFaisal.ce I am delighted to inform you that I have successfully overcome the previous issue and fulfilled the intent. To be specific, I solve the problem in a tricky way. Thanks once again for your interesting observation, which is very helpful when solving the problem. This leads to...

Dear MFaisal.ce Thank you once again for your patience and for clarifying the intent. Keeping the data will be difficult as we remove all the links. However, the Information or Observation you have shared brings hope. Currently, I am trying to solve this from another angle. When I am done, I...

Dear Mfaisal.ce Thanks for reaching out and posting your problem. You want to open several files with the same data format. You want to apply a date format within all sheets of a workbook. And you also wanted to remove or disable all links from a workbook. I am presenting two Excel VBA...

Dear VVK I am happy to inform you that I have succeeded in developing the proposed Excel VBA sub-procedure. To be specific, the sub-procedure I am going to present is more convenient than the proposal. It is yet to be mentioned that the sub-procedure can now work with the selected range. You...

Dear VVK Thanks for reaching out again. It is my pleasure that you like the idea I previously provided to fulfil your requirements. You are now interested in whether the provided Excel VBA sub-procedure can support making the Source Language Text dynamic. I am delighted to inform you that I...

Hello VVK Welcome to ExcelDemy Forum. You wanted a macro that will work with relative reference for coping output from Excel Translator. You are right about the error mentioned error. I have studied the situation, but I cannot access the Translate command under the Language group in the Review...

Dear Habib Your project deadline is before Friday. So, within this time duration, you need two Excel VBA Sub-Procedures to solve the Sine Values and the Forecast Values problems. As mentioned earlier, I went through these problem explanations (SINE & FORECAST) and did not understand them. With...

Dear Vera You are most welcome. I am pleased to hear that it worked perfectly. If you get stuck with more exciting problems like this, do not hesitate to reach ExcelDemy Forum. Stay Blessed. Regards Lutfor Rahman Shimanto ExcelDemy Team