In this article, we have explored 2 easy methods of how to make periodic table in Excel. The first one is manual. It involves various functions and features of ...
In this article, we have explored how to declare Excel VBA global constant. We have demonstrated 2 convenient ways to declare global constants. Then, we ...
In this article, we will show you how to perform data analysis and visualization with Excel. There are three stages in data analysis and visualization. To ...
In this article, we have talked about how to use the CONCAT function in Excel. We have demonstrated various examples of using the CONCAT function with texts, ...
The timestamp is widely used to record and analyze time-based information, such as financial transactions, online meetings, and event logs. However, dealing ...
In this article, we will use Excel VBA to filter Pivot Table Based on a list. The list can be an array, range, or a dynamic named range. Imagine a scenario ...
Are you tired of spending countless hours manually creating charts from your Pivot Tables in Excel? Well, afraid no more! We can use Excel VBA to create chart ...
If you have been using Excel for some time, you probably know that VBA is a powerful tool to automate your tasks and streamline your workflows. But did you ...
Are you tired of manually sorting data in Excel to find and add up values based on cell color? Look no further than the Excel SUMIF function. This powerful ...
A ComboBox is a strong tool that allows users to select from a list of predefined items. However, if the list is too big, It may become difficult for the user ...
While working with large datasets in Excel, it is very common to look for specific values with certain criteria. INDEX and MATCH functions can be used together ...
Have you ever seen long lines of text that extend beyond the cell’s boundaries? or text that does not fit within the cell’s width? If your answer is yes, ...
It is very common to use VBA in Excel to capitalize all letters in a range of cells. Capitalizing letters is a very straightforward process in Excel VBA. In ...
Runtime error 438 in Excel VBA is a very common error that is caused by referencing an object or property that doesn’t exist or is not recognized by the Excel ...
VBA (Visual Basic Application) is a powerful programming language that allows you to automate different tasks in Excel. One of the most useful functions of VBA ...
Hi,
Thank you for your comment. From the problem you have stated, it looks like you need to just modify the previous code a little bit. You can use the following code to accomplish your task.
Regards,
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Dear VSP
Thank you very much for your question. I appreciate your interest in our article. I will show you the step-by-step process to create a macro according to your preferences. Also, you will be able to send automated emails on the due date without running the code.
● First, create the workbook. I am creating a sample workbook that has Message, Date, Status of work, and Email addresses in specific positions that you have mentioned.
● Select your entire dataset.
● Go to the Insert tab >> Table.
● Check the My table has headers option.
● Press OK.
● Sort your data according to your Email address.
● Now go to the Developer tab >> Visual Basic.
● Go to ThisWorkbook and paste the following code into the VBA Macro Editor.
● Save the file as Excel Macro-Enabled Workbook (.xlsm) file.
● Now, to automatically send emails, type Run in your Start Menu and open the Run dialog box.
● Paste the following path there and press OK.
%AppData%\Microsoft\Windows\Start Menu\Programs\Startup
● Place your Excel file in the Startup folder.
Now whenever you open your PC, the VBA code of your Excel file will be automatically executed. Emails will be sent to the given email addresses according to the criteria you mentioned.
Notes:
● Stay logged in to your outlook application. We are using the OUTLOOK Microsoft 365 Office application.
● The provided code sends an email for the current date. You can customize it for any date.
● Make sure that your active worksheet contains the sorted table and save the file accordingly.
You can download the sample Excel file from here.
Send Emails.xlsm
If you have any more questions, please let us know in the comment sections.
Regards,
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Dear SHERI
Thank you very much for your inquiry. I appreciate your interest in our article. You can copy worksheets from one workbook to another without mentioning the names of the worksheets. You have to slightly change the VBA code. I have modified the code and provided it here for your convenience.
Keep two things in mind before running the code:
● You must keep both workbooks open.
● You must run the code in the destination workbook.
Paste this code in the VBA Macro Editor of your destination workbook and press the Run button or F5 key to run the code.
If you have any more questions, please let us know in the comment section.
Regards
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Dear NIRMAL
Thank you for taking the time to read this article. I can see that you are facing a problem while executing the code in method 3. I guess It is Run-time error ‘1004’.
Kindly note that you need to modify the file path according to the folder where you are storing your pictures. You also have to specify the type of the image (jpg, jpeg, png, etc.) correctly. So, you should change the LocationPic variable in the code accordingly.
For your convenience, I am attaching a photo indicating the exact portions of the code that you need to re-write.
If you have any more questions, please let us know in the comments.
Regards
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Dear BENJAMIN THORPE
Thank you very much for your interest in our article. You can create an auto-prompt dropdown in Excel. In the dataset, we have the names of multiple people.
Simply follow the steps below:
● Go to the Developer tab >> Insert >> Combo Box (ActiveX Control).
● Then place the newly created ComboBox.
● Double-click on the ComboBox.
● A VBA window will pop up. Paste the following code into the window.
● Now, go back to the worksheet and click on the Design Mode from the Developer tab to turn it off.
● Double-click on the ComboBox and you will see an InputBox asking for the list.
● Select the list from your dataset and press OK.
● You will have the auto-prompt drop-down list.
You can also download the Excel file from here.
Excel Auto Prompt Drop-Down.xlsm
If you have any more queries, please let us know in the comments.
Regards
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Dear KAZEM
Thank you for taking the time to read this article. I see that you are facing a problem while executing the code. It is the Run-time error ‘1004’. There are several possible reasons for this error. In your case, I believe you are having this issue because the file path you specified is incorrect or unavailable. Please note that you need to modify the file path according to the destination where you want to save the PDF file. You have to change the file path portion in the Filename variable.
For your convenience, I am attaching a photo indicating the exact portion of the code that you need to re-write.
If you have any more questions, please let us know in the comments.
Regards
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Hi SUMBO,
We have sent you an email. Please see the attached document in it.
Regards
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Hello Z L
Thank you very much for your response. We have modified this article and introduced some new statistical concepts and functions. Would you please go through it again?
If you have any more questions, let us know in the comment section.
Thanks
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Hi YOGAAGA
Thank you very much for your comment. A few limitations while working with these functions have been discussed in the NOTES section. Please go through them. In addition, here in the dataset, the VLOOKUP function has been used in combination with the LARGE function. Both the VLOOPUP and LARGE functions go through the entire range of data every time they are called. The LARGE function needs to sort the data before determining the result. The VLOOKUP function looks for the data in a specified range. The whole process can be computationally expensive in large datasets. So, this formula can be time-consuming when dealing with large amounts of data.
Moreover, this formula may return identical values if it encounters duplicates in the dataset. For example, in our dataset, if there are multiple students with the same CGPA, the formula will return the same student’s name for each duplicate value.
Thank you once again. Let me know in the comments if you have any further queries.
Regards,
Md. Abu Sina Ibne Albaruni
Team ExcelDemy
Dear Datla Srinivas,
We have sent you an email. Please find the attached documents in it.
Best wishes
Md. Abu Sina Ibne Albaruni
Team ExcelDemy