Search results

Dear Afoster, Thanks for thanking me! You are welcome. Your appreciation means a lot to us. You are right about not deleting the rows below the number of payments; it hides the rows. Thanks once again for letting us know that the previously provided worked perfectly as you intended. Stay...

Dear Tam Thanks for reaching out and sharing your question. You want to delete the empty columns from two sheets in your Excel workbook. But you want to run the macro once. You want a macro that deletes empty columns from two sheets. Don't worry! I have improved the sub-procedure you provided...

Dear Thanks for sharing your findings regarding the previously provided VBA sub-procedure. You mentioned that for the same values in Column N, it will ignore the Negative Values in Column N to get the Max Value SubArray in Column O. You want to modify the VBA Code, which includes ALL range...

Dear Lisa Gordon Thanks for reaching out and sharing your query. Thanks once again for your patience. I have reviewed your requirements and found an excellent solution you will like. You have mentioned that you are managing attendance and meal records for four classes. Each class has its own...

Dear Jululian, You are most welcome. Your appreciation means a lot to us.

Dear Afoster, Thanks for letting us know that the previously provided VBA Sub-Procedure and Event procedure worked perfectly on your end. I have improved the file and fulfilled your requirements by dragging the existing formulas for the C, D, and E columns up to 100 rows. Please check the...

Hello Jululian It is good to see you again. You wanted to find the weight based on criteria such as height (155 cm) and age (between points), for example, 0 to 24, 25 to 29, etc. Don't worry! I have developed a complex formula to fulfil your goal. However, I had to modify the heading a bit. I...

Dear, It is great to know that the solution worked perfectly on your end and successfully achieved the expected result. Thanks for thanking me; you are welcome. We really appreciate your thoughts about creating new threads for new problems. I would say it is very visitor-friendly, as many...

Dear Afoster Thanks for staying with ExcelDemy Forum! I have reviewed your problem and come up with a solution. I have made two Excel VBA Sub-procedures and called them in a Worksheet_Change event. So, instead of using the GenerateSequence user-defined function, all you need to do is put the...

Dear Afoster Thanks for staying with ExcelDemy Forum. I have found the reason why you are having trouble. You are getting an error on the highlighted line because you are not correctly using the GenerateSequence user-defined function in cell B4. You do not need to copy the formula down to cell...

Dear Afoster Perhaps the Excel Version is not the reason. The Worksheet_Calculate event is available in almost all versions of Excel VBA, including the most widely used versions, including Excel 2003 and onwards (2007, 2010, 2013, etc.). Do not worry! Currently, I am investigating your...

Dear Afoster Thanks for thanking me. You were almost there. However, you faced several problems. Do not worry! I will try to explain the procedures more clearly. Let us discuss your first problem. In my previous reply, I tried to refer to cell B5 by writing the intended cell (in step 4)...

Hello Afoster Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem. You mentioned that your Excel version does not have the SEQUENCE function. Do not worry! I have come up with a solution that generates sequences based on the number of payments using an Excel VBA...

Hello Dear It is great to chat with you as well. Thanks for staying with ExcelDemy Forum and considering ExcelDemy as your trusted website. We appreciate your concern. Unfortunately, there is no way to trust all VBA code downloaded from a specific website globally. Do not worry! I have come up...

Dear Gary Thornton Thanks for your nice words. Based on your reply, it seems you want to modify the formula. Instead of displaying Order, you want to display 1. You also want to consider January, April, July, and October as the triggering months to reorder the product; this means 1 has to be...

Dear, it is good to see you again. Thanks for sharing your requirements. You want to find the vertical subarray in Column N, where the sum of the corresponding elements in Column O is maximized. I am delighted to inform you that I have developed an Excel VBA Sub-procedure to fulfil your goal...

Hello GimpyHand Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem. You are trying to filter a table in Excel based on specific criteria. We have demonstrated your situation and fulfilled your goal using the Excel FILTER function. SOLUTION Overview: I have...

Hello Gary Thornton Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your requirements. Assuming you want to start ordering in January and repeat every three months, you can combine the IF, MOD, MONTH, DATE, and YEAR functions. I have tried to demonstrate your situation, like...

Hello Maroof702 Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem with us. You want to create tabs within tabs with the existing formulas and VBA code attached in the Excel file. After reviewing your file, I saw that the tabs within the Store2 sheet are not working...

Dear, I am glad that the improved sub-procedure code has worked perfectly so far. Copying the desired results into the "2024 MLB.xlsm" workbook from "2024 MLB EXCELDEMY.xlsm" is an obvious solution. I appreciate naming our provided file "2024MLBEXCELDEMY.xlsm," assuming a creative way of...