Search results

Dear Gwolfe7, Usually, VBA doesn't require the declaration of variables beforehand. However, you may try the following code where I have explicitly declared each variable. Sub MoveCheckedData() Dim ws1 As Worksheet, ws2 As Worksheet Dim rng As Range Dim chkBox As CheckBox Dim...

Dear Gwolfe7, Welocome to Exceldemy forum. Thanks for posting your problem. Based on your requirements, I have developed a VBA code that will move the value in a cell on column B only if the corresponding checkbox on the cell of column G is checked. This task can be accomplished effortlessly by...

Dear NMZ1133, Thank you for posting in our Exceldemy forum. I have created a VBA macro that sorts cells in alphabetical order in Excel. After entering new data, you can run the macro by clicking a button on this worksheet. Please take a look at the image below for a better understanding: The...

Dear Alqahtanir, Welcome to Exceldemy Forum! Thank you for posting your queries regarding VBA Macro. At Exceldemy Blog, we provide an extensive range of resources that can assist you in learning how to create VBA Macro from scratch. Our articles cover basic to advanced level VBA topics, and we...

Hello Nikhil, Thank you for posting your query on Exceldemy Forum. However, without examining how you have organized your data and utilized the advanced filter feature in conjunction with a VBA macro, it's not possible for us to offer a workable solution. Would you be able to provide a sample...

Dear AMANZ, Unfortunately, I was unable to extract data from a URL that requires authentication using any other function. However, you can try using the "Get Data From Web" feature to see if it works for you. To do that, Go to Data/ Analysis tab, select From Web option, enter your url on the...

You're very welcome! Glad to know that it worked for you. For your everyday Excel solutions, stay with Exceldemy.

Dear Faisal, Thanks for posting on our Exceldemy forum. You can easily accomplish that by running the following macro code. I wasn't able to directly write the code on your file as it is password-protected. However, you can paste the following code on your file and run it. Sub...

You are most welcome. Feel free to reach us for any further assistance.

From your shared screenshot, I can't see any column for Material. In order to look up a value in Excel, we need to maintain a certain structure so that we can formulate a lookup formula using different lookup functions (such as VLOOKUP, HLOOKUP, XLOOKUP, etc). For example, I have taken sample...

Dear Aneek, Thank you for posting on the Excedemy Forum. I have prepared a Macro-enabled Excel workbook that will do the job for you. You can run the macro using this button to create a new committe that will populate each batch randomely. Make sure you enable Macro before clicking the button...

Hello Coco, Thank you for your post. However, in your post, it is not clear where the "steel" lookup value will be located in the lookup table. Could you please provide a sample dataset to help us gain a complete understanding of how your data is organized? Thank you in advance for your...

Sure, to achieve your goal, you can use the following approach: First, create a helper column in the first sheet (Lapas1 in this case) to calculate the total "p" in each row using the COUNTIF function. =COUNTIF(B2:F2,"p") Next, go to the 2nd sheet and use the SUMIF function to sum the total...

You are most welcome. It was our pleasure to assist you! Feel free to reach out again if you need any more help. Have a wonderful day!

Hello Valdas, Thank you for reaching out to our forum for assistance. Unfortunately, we weren't able to sum up all the cells in a row based on the criteria you provided. However, I have created a custom function called "Sum_with_Condition" using VBA code to help you achieve your desired...

You're very welcome! I'm thrilled that it worked for you. Don't hesitate to come back to Exceldemy for any of your Excel-related needs. We're always here to help! Best regards, Aniruddah Team Exceldemy

Hi Ashish, Thank you for getting in touch with us. I've reviewed the worksheet you shared and noticed that you attempted to use the LOOKUP function, but the lookup_array wasn't sorted in ascending order. Please note that for the LOOKUP function to work properly, the lookup_array must be sorted...

Hi Chteoh, I've created a VBA code that will help you achieve what you need. I've attached the file here. To run the code, use the button provided on the worksheet. As per your request, this time the emails won't be sent directly, but instead, they will be saved in the Draft section. This way...

Dear LookingForHelp! Thanks for posting in the Exceldemy Forum. By looking at your problem, I believe we can provide a solution. But before that, I just wanted to clarify something. I understood the first part of your post, but I'm a little unsure about the latter part where you mentioned...

Hello Chteoh, I have created a file with VBA code that can help you split your main file into a smaller one that contains only the row of the selected cell. To use the file, simply go to the Sample Data sheet and click on the button provided. This will open up an input box that will prompt you...