Recent content by Aniruddah Alam

Hi Luke, Thanks for reaching out again. Sorry for my late reply. Based on your new requirements, I have created 2 new User Defined Functions named GetmAGL and Get_PreviousData. Below is their descriptions: GetmAGL(HoleID As Range, Date_Measured As Range, Excel_table As Range): It takes three...

Hello Lukeh81, Based on your description, I have created a file that contains the formula that you might be looking for. To be specific, I have used a formula in the G column, which looks like this: =VLOOKUP([@HoleID],Table1,2,FALSE)-[@WL] Table1 refers to the Table A in your file. You can...

Dear Timbetom, Thank you for posting your query on our Exceldemy forum. Without seeing your code, it's difficult to diagnose the problem accurately. You're right that when converting code from 32 bits to 64 bits, all the Declare statements need to be updated to "PtrSafe Declare". Additionally...

Dear Joel, Thank you for your post on our Exceldemy forum. Could you provide more details about your requirements? Regarding the Leave Table sheet, would you like to have a single row for each employee? If so, how would you like to store the days when an employee takes leave on multiple days...

Glad to know it worked. Regards

Dear Ahmed, Thank you for posting on our Excedemy forum. Based on the requirements you mentioned, I have developed a VBA code for you. You can run the code by clicking on the phone icon (on the right side of the truck icon). This code will transfer any newly added phone numbers in column O of...

Dear Anthony, You are most welcome

Dear Anthony, I apologize for the delay in replying. I have reviewed your file and identified the issue. The problem is with the naming of the range. To ensure that the FILTER function provides accurate results, you need to select the entire B:G range for the named range, Task. This is because...

Dear R. Coon, Thank you for reaching out with your query. I'm pleased to assist you! VBA is an excellent choice for achieving your goal, offering a straightforward solution compared to regular Excel formulas. I've crafted a VBA code to seamlessly combine text from a selected range of cells...

As you are already able to run the macro in this file on your computer, it is already unblocked hence you will not see the Unblock checkbox. However, on your user's computer, it will display an Unblock checkbox like this: Checking this checkbox should enable the users to run macros on their...

Hi Gwolfe7, Enabling macros using VBA code isn't possible because of security concerns. But don't worry, there's an easy way to enable macros in Excel files created on other computers without having to go to the Trust Center settings. Just follow these simple steps and let us know if they work...

Hey Aneek, thanks for sharing your problem with us. It looks like your requirements might need some advanced algorithms, which is a bit beyond what our forum usually handles. No worries, though! You can try our Exceldemy Consultancy Service, where we create custom Excel solutions for folks. Give...

For that, you need to AutoFit column A of the Summary sheet. To do that, add the following line below Sheets("Summary").Activate line: Sheets("Summary").Columns(1).AutoFit Regards Aniruddah

Glad to hear that. Best Wishes Aniruddah

For that, you can put the following 2 lines of code below ws2.Range("A" & i).Value = copied_value line: ws2.Range("A" & i).Font.Color = RGB(255, 255, 255) ' RGB value of White color ws2.Range("A" & i).Interior.Color = RGB(123, 36, 11) ' RGB value of #7B240B Regards Aniruddah