Search results

Hello Vipinpanchal2008 Thanks for your comment and for noticing the problem. After investigating the issue, I recommend you define the cellAddress variable as ranges instead of cells. For example, cellAddresses = Array("B5:L29", "B31:L55", "B64:L86", "B88:L112") The idea will overcome...

Hello BigMe Thanks for posting your queries with such clarity. You are absolutely right about the global variable. The public or global variable can be accessed with other modules. However, we can not directly use the value inside the global variable. To overcome the situation, we can create a...

Wa alaykumu s-salam Haas I'm deeply saddened to hear about Laeeq's passing. May Allah SWT grant him a place in JanatulFirdose and provide comfort and strength to you and your family. Ameen

Dear Maps You're very welcome! I appreciate your kind words, and I'm glad I tried to assist you with your query. Calculating holidays for a large number of employees can indeed be a complex task, especially if there isn't a simpler formula readily available. If anything even comes to my mind...

Hello VipinPanchal2008 You are most welcome to the ExcelDemy Forum. Thanks for reaching out and posting your queries. You wanted to insert multiple images in merged cells. I am delighted to inform you that I have developed an Excel VBA sub-procedure to reach your goal. Thanks for the code you...

Hello Maps Thanks for explaining your problem with such clarity. You are right about missing minute values when using the previous formula. You have shown that employees who reported for duty on 3 August in the evening shift had to be paid holiday hours from 00.00 to 07.15 on the 4th, which is...

Hello Maps It is great to see you again. Thank you for posting your queries with such clarity. I went through your attached workbook and analyzed your requirements. What I have found is that it is technically impossible to calculate the Holiday Working Hours only using an Excel Formula. In...

Hello Ravio You are welcome to ExcelDemy Forum, Ravi! Thank you for reaching out and sharing your queries. You mentioned that you are using Excel 10. While trying to use the slicer option, it is showing no connection found. In older versions of Excel, such as Excel 2010 and earlier, slicers...

Dear JOJO Thanks for reaching out and sharing your problem. The problem you describe is not 100% clear to us. However, after going through the screenshot, I understand that you want to perform the Cumulative Sliding Scales. I have divided the goal into two requirements. Requirement 1: For the...

Hello Chili Thanks for reaching out and posting your problem. You want to prepare a chart using the given dataset, including the mentioned location name. I am delighted to inform you that I have developed a chart that meets your requirements. To begin, select range A15:C25 >> go to Insert >>...

Dear Haas, Wa alaykumu s-salam! I'm deeply sorry to hear about your brother Laeeq's current ICU condition. My thoughts and prayers are with you and your family during this challenging time. May Allah grant him a swift and complete recovery. Take care Lutfor Rahman Shimanto

Dear Haas I am sorry to inform you I cannot understand the problem regarding FORECASTING VALUES and SINE CURVE VALUES. I do not have the proper concept of how to calculate it manually. If I knew how to calculate these values mathematically, maybe I could develop the idea within Excel VBA. For...

Dear Haas Wa alaykumu s-salam! You are most welcome. You want to take the Source Data from Sheet1 and store Target Result on Sheet2 or Sheet3. To meet your new requirements, I have changed the previous code. Source Data: Requirement 1: Sub CountColoredCellsWithColorBackground() Dim...

Dear Arc Poojari Thanks once again for bringing up such an interesting problem. Previously, I have shown you the overview of the whole system. Throughout this reply, I will guide you step-by-step in reaching your goal. Dataset: Drop-Down: Other Sheets: VBA Code within Drop Down Sheet...

Hello Arc Poojari Thanks for reaching out and posting your queries with such clarity. Requirement: You have a database with details of sales done by a different salesperson. You want to restrict them from viewing other salespeople's data. Your Excel sheet works on a drop-down list. You asked...

Dear Haas Thank you for being so patient and staying with ExcelDemy Forum. It's my bad! When modifying the code based on the Source and Target ranges, I failed to notice and change the lstRowSrc variable. I am delighted to inform you that the below code will not disappoint you. I am attaching...

Dear Haas I have reviewed the code and tested it several times. You are right about the raised issue. Currently, I am on to it. When I find a solution, I will share the idea in this thread. Regards Lutfor Rahman Shimanto

Hi Haas, Wa alaykumu s-salam! Thank you for your message! I truly appreciate your kind words. It's wonderful to hear that you found my input valuable. Sending my regards to you and your family. Take care and stay well! Best regards, Lutfor Rahman Shimanto

Dear Haas Thank you for staying with ExcelDemy Forum. You asked to modify the previous code so that you can easily change the destination range if needed. I am delighted to inform you that I have modified the code as requested. Requirement 1: You must run the sub-procedure named...

Dear Haas, Wa alaykumu s-salam! Thanks a ton for your kind words. Currently, I am working on the modification of the previous code. It will take half an hour to reach your goal. Stay with ExcelDemy Forum. Regards Lutfor Rahman Shimanto