Search results

Hello Faisal, Fortunately, yes! There is a way to get an email when Excel file gets unprotected. Here is the custom code to do so: Dim objExcel, objWorkbook, objShell Dim strExcelFilePath, strPassword ' Set the path to the Excel file and the password (if any) strExcelFilePath =...

Hello Mark, Thanks for posting your concern in this community. Per the description shared, I understand your concern and I am sorry to convey that there is no related ExcelDemy blog explaining the backend mechanism on recommended charts in the Excel app. Although I would like to share an...

Hello @Golf Automation, I think I have understood your concern now and fixed it accordingly. Check it out and let me know if you have further concerns. Best Regards.

Hello @Golf Automation, Please, see the attached Excel file. I have included the parameters as requested. The report is on the second sheet. Hope this works for you.

Hello, The spreadsheet supplied does NOT have a column for what PAR is for any hole (unless it is hidden somewhere). Without a value for PAR for each hole it is impossible to do the required calculations. Not sure about the details of your rules even when par scores are available: I think...

Hello Sam, Thanks for the thorough explanation. I have modified the provided code so that the color index automatically updates whenever the color of the cell changes. I have used Worksheet_Change event in VBA to do so. The modified code: Private Sub Worksheet_Change(ByVal Target As Range)...

Hello Sam, Welcome to ExcelDemy forum! I understand you wish to auto update the COLORLN function. Is this a VBA function? Or are you referring to a conditional formatting function? Please clarify. And if it is a VBA function, please provide the VBA code. We will try to provide the best...

Dear Shaima, Thank you for your query. I understand you wish to extract the first and last matches from Column D based on multiple criteria. I see you used VLOOKUP to get the first value with a helper column. But you were not able to obtain the last matching value. This is so common because...

Dear Golf Automation, Welcome to ExcelDemy forum! I understand you wish to extract data to build a Golf-Skins Report; Multiple Winners Per Hole. Fortunately, you can do this using the lookup & Transpose functions. The skins round generally works by the lowest score on a hole, if scored by only...

Dear Santosh, Another indication of the UserForm being greyed out could be because of the VBA installation or settings are not properly configured. Please try the following steps to enable the UserForm option: Step-1: Check Excel Options: Open MS Excel and go to the File menu. Click on...

Hello Sidbloom, Welcome to ExcelDemy forum! I see you have tried quite a few ways to fix your UserForm being greyed out. Have you tried enabling all macros in Excel? Sometimes, we miss out these small matters in complex situations like this. To enable all macros, First, go to File > Options...

Hello John, Thank you for your feedback. In your second post, I understand you want us to create a template related to your first post. But creating such projects or templates could involve a lot of effort and time, and frankly quite impossible if the proper environment is unknown. In this...

Dear Chilli, Thank you for your feedback. Check the attached Excel file. It contains the desired calculations using Excel generic formula. If you wish to calculate more columns, use Red font in the respective column and share the Excel file here. Thank you. Best Regards.

Hello John, Welcome to ExcelDemy Forum! I think you wish to create a function in Excel where you input a name and the meaning of the respective name will appear. Unfortunately, Microsoft Excel does not provide any in-built service like this. I am not sure what the guy in the Tiktok video is...

Dear Chili, Thank you for your post. Although we would greatly appreciate it if you could explain the dataset in more detail. For example, do we need to calculate the After Increment column? and if we do, how do we calculate it? I have formulated the summary report as I understood from the...

Dear Faisal, I understand you wish to compare two Cells having different strings to give a result that is common in both. To do so, use the split function in a macro to separate out the elements from both cells then loop through both sets to compare for equality. Although your question seems...

Dear Zeke, Thanks again for the detailed explanation. Your simplified Fragrance in a Bottle model seems to lack information about refilling the bottle when it gets low. I can't tell you HOW or WHEN to do that because I can't see what else you are doing. This is still a variant of an inventory...

Hello Zeke, Welcome to ExcelDemy Forum! Thank you for the thorough explanation. Although a demo dataset would help a lot. I understand you wish to monitor a container's volume/Inventory. Here is our suggestion to do so. Adding or subtracting some increment from a container total is a common...

Dear Faisal, Welcome to ExcelDemy forum! I am having trouble understanding your requirements. Care to explain a little more so everyone would have an idea as to what your problem is? Might be worth uploading the workbook with detailed instructions on how to recreate it. Thank you. Best...

Hello, Welcome to our ExcelDemy forum! I understand you wish to create a Mailing Facility within Local Area Network with VBA. Here are some thoughts you can use for the lead. If there is a Common folder (shared folder) on your LAN that anybody can access (read/write), you can put a Text file...