Search results

Dear, thanks for letting us know that the solution worked perfectly. You are most welcome. Regards ExcelDemy

Dear, Thanks for providing the link to the original MLB Baseball Schedule and Scores Website. I am delighted to inform you that I have overcome your situation with the help of two more VBA User-defined functions and the improved VBA Sub-procedure. SOLUTION Overview: Copying Data from Website...

Dear, thanks for your patience. As mentioned, I can develop two individual sub-procedures for the Home and Visitor teams. However, I think the existing code is powerful enough to complete all the required tasks. After you download your Excel data from another website, share a screenshot of it...

Dear, thanks for clarifying the original baseball games and scores downloaded online. You have mentioned that all other Visitor Team 3 Letter Symbols, Visitor Team Scores, and Home Team Scores are displayed as expected. But on your machine, the sub-procedure is not displaying the Home Team 3...

Hello Boy282828 Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem with such clarity and well-layout. I have reviewed your requirements and demonstrated the situation. I am delighted to inform you that I have developed a solution by creating an Excel VBA Sub-procedure...

Hello Cljavier Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your queries. We have reviewed your work and the dataset and found that the data you provided depicts a negatively skewed distribution, not a positively skewed one. The skewness value signifies a negative skew, in...

Hello Drbiggs Thanks for reaching out and sharing your problem with such clarity. I have demonstrated your situation in a solution workbook. I think using the cell references instead of named ranges is better. However, if you need to use named ranges, I have enhanced the formula: I have...

Dear AVH Welcome to ExcelDemy Forum. Thanks for reaching out and sharing your problem. I am delighted to inform you that I have developed an Excel VBA Sub-Procedure that will achieve your goal. Follow these steps: Press Alt + F11 to open the VBE. Click on Insert followed by Module. Paste the...

Dear Jululian, thanks for your kind words. You are most welcome.

Dear Vignesh Thanks for your kind words. I am delighted to hear that the code fulfilled your goal. You want to save the generated documents in a particular folder with the test case name or number, e.g., TC-1, and each step should have a space. I have developed another Excel VBA Sub-procedure...

Hello Muhammad Al-Bunni Thanks for sharing your query. Unfortunately, directly linking cells between Excel files on mobile devices isn't readily available. Here are two options for transferring data automatically: Google Sheets Formulas: If your files are saved on Google Drive, you can use...

Hello Jululian We have reviewed your dataset and found that developing a formula using Excel's built-in functions to find sales rank based on department and section would be time-consuming. So, we recommend using an Excel VBA User-defined function to meet your expectations when calculating...

Dear Simon Goodman. You are most welcome.

Hello Simon Goodman Thank you very much for explaining further. After reading your explanation, I understand you have a user-defined function named Command, which is used in an Excel VBA Workbook_Open event. You have tried opening the workbook using various methods, including a PowerShell...

Hello Simon Goodman Thanks for sharing your questions. There are a couple of reasons why you might be getting a null value from your Command() function despite no errors being recorded. In VBA, variables declared within a Sub or Function are local to that procedure. So, it won't be available...

Hello Vignesh Thanks for reaching out and sharing your query with such clarity. I am delighted to inform you that I have developed an Excel VBA Sub-procedure to fulfil your goal. Assuming your data structure is like the following GIF. Follow these steps: Press Alt+F11. Insert the following...

Dear BigMe You're most welcome! Thanks for thanking me. Regards Lutfor Rahman Shimanto ExcelDemy

Dear BigMe You're most welcome! I'm delighted to hear that the solution worked for you. Warm Regards Lutfor Rahman Shimanto ExcelDemy

Hello BigMe Thanks for reaching out and sharing your problem. You want to set the Thousand Separator using period (.) and the Decimal Separator using comma (,). To do so, follow these ‍steps: Press Alt+F+T to open Excel Options. In the Excel Options window: Click on Advanced. Uncheck Use...

Hello BigMe Thanks for sharing your problem. You wanted to print all sheets in a workbook with the same page layout format, etc. I am delighted to inform you that I have developed a sub-procedure to fulfil your goal. I am assuming your data and sheets are like the following GIF. To print...