Search results

Hello Ihab Welcome to ExcelDemy Forum. Thank you for sharing your expertise with our ExcelDemy Forum! The extra values you added are effective. We appreciate you sharing your formulas with us, and we feel it will benefit others who visit our thread. Formulas (Contributed by Ihab): Thanks...

Dear AhmdHM Thanks for your appreciation. You are most welcome. Regards Lutfor Rahman Shimanto ExcelDemy

Hello Bigme Thanks for your nice words. You are most welcome. Regards Lutfor Rahman Shimanto ExcelDemy

Hello AhmdHM Thanks for reaching out and sharing your problem. You wanted a VBA code that searches for the Pat_Code in the Main sheet; if the code doesn't exist in the LineList, it will be added in the next row. I am delighted to inform you that I have developed an Excel VBA Sub-procedure to...

Hello GSFRAGARO Welcome to ExcelDemy Form. Thanks for sharing your problem. You have encountered an issue like you have a string with two consecutive zeros, but the code generates an empty character. In Our machine, the code and font work perfectly fine if we have a string with two consecutive...

Hello Saood Ahmed Thanks for reaching out and sharing your problem. The requirements you described can be reached using a Helper column. I am happy to inform you that I developed an idea and some formulas using the COUNTIF, INDEX and MATCH functions. Follow these steps: Step 1: Select cell C3...

Hello Koolrk Thanks for sharing your problem. In your office, you have Excel 2007. So, you need formulas that are compatible with the Excel 2007 version. I am delighted to inform you that I have developed some formulas to fulfil your requirements using the IFERROR, AVERAGEIFS, SUMIFS...

Hello Richard Welcome to ExcelDemy Forum. Thanks for reaching out and sharing your problem. Without embedding, you wanted to insert a Word Document as a tab within an Excel Workbook. That is not entirely possible in Excel. However, I am presenting an idea which will fulfil your requirements in...

Hello BigMe Thanks for sharing your problem with such clarity. You have several pdf files in a specific folder. You want to copy some of the files and save them to other folders, then open all those saved files using VBA. Assuming your dataset is like the following GIF. I am delighted to...

Hello Bino1121 It is good to see you again at the ExcelDemy Forum. Thanks for sharing your problem with such clarity. I am delighted to inform you that I have developed an Excel Event Procedure and a Sub-procedure to fulfil your requirements. I modified some of your given sub-procedure and...

Hello Lucas Thanks for reaching out and sharing your queries. The presented User-defined function for calculating UTM Northing in the article should be compatible with most versions of Excel. If you want more compatibility, consider making a few adjustments: replacing the # symbol (used to...

Hello Nikhil Patki Thank you for getting back to us, and I appreciate your diligence in checking your spam/junk and inbox folders. We will ensure you receive another copy of our response by next Sunday. Stay Blessed. Regards Lutfor Rahman Shimanto Excel & VBA Developer ExcelDemy

Hello Nikhil Patki I understand the complexity of your workbook structure with multiple columns of employee details and attendance records and the need to extract specific information from another sheet. One practical approach is to use relative references when creating links to address the...

Dear Nikhil Patki I'm delighted to hear that you found our support helpful and that you've been learning a lot about Excel. The formula presented here is a basic demonstration to solve that problem. Of course, these formulas can be enhanced to dynamically calculate dynamic fuel-filling entries...

Dear Nikhil Patki We value your time and appreciate your patience in this matter. We have sent a response to your email. Kindly check your inbox, including the spam or promotions. If, for any reason, you are unable to locate our response, please let us know, and we will be more than happy to...

Hello Nikhil Patki Thanks for sharing your queries. If we create links within a workbook in Excel, the links are generated based on the file location and name. When you change the workbook's filename or destination, the links will break because the original file path or sheet name no longer...

Hello Nikhil Patki Thanks for sharing about you and your requirements. To manage all these tasks, I recommend developing an Excel-based system. To develop such a System, you can consider getting support from Excel Consultancy Services of ExcelDemy, where you will get consultancies at minimal...

Hello Nikhil Patki Assuming your data is in columns A to D (Date, Veh No, Op Km, Qty). Follow these steps: Step 1: Total KM Running Select cell G2 => Insert the following formula => Hit Enter. Step 2: Total Fuel Consumed Select cell G3 => Insert the following formula => Press Enter...

Dear Nikhil Patki Thanks for sharing your problem with such clarity. I am presenting an Event Procedure that will fulfil your requirements. You must keep that Event Procedure within the sheet module. Excel VBA Event Procedure: Private Sub Worksheet_Change(ByVal Target As Range) If...

Dear BigMe Thanks for your queries. Unfortunately, you can not keep that code in a module. You must keep the code in the sheet module because the previous code is an Event Procedure. However, we can modify the previous code and turn that into a Sub-procedure. Excel VBA Sub-procedure: Sub...