Search results

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

Dear Bino, 1. I actually made a mistake in declaring the variables 'r' and 'last_used_row' as Integer and Double, respectively, instead of Long. As the Integer data type can only hold values ranging from -32768 to 32768, it is safer to use Long type when there are chances of exceeding the range...

Thanks bino1121 for your post. From your code, it's not clear to me what you want to do with the variable lr. Are you trying to locate the last row of your dataset by manually inserting a "*" on the last row and then finding its row number? If that is the case, then I am giving an improved code...

I'm sorry, but the requirements you have stated in your post cannot be achieved using built-in Excel formulas or functions. Your requirement is dynamic, and therefore, using VBA is the only solution that comes to my mind. If you are not familiar with VBA, you can read this introductory article...

Hey there! It's great to hear that you've got the command line for showing the Summary sheet after copying the data into it. If you need any more help or have any questions, please feel free to reach out to us anytime. Our Exceldemy team is always happy to assist you in any way we can! Best...

Dear Ben.cote, Thanks for posting on our Exceldemy Forum. According to your requirements, I have developed an event-driven VBA code that will record the data entry time when any cell value is changed on a specified range [inputRange = Range("C9:N16")]. The VBA code is given below: Option...