This article shows how to refresh a worksheet or chart at regular intervals. This exercise builds a timer that refreshes the worksheet every one minute, reflecting changes in the source data.
This article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
An example of the workbook used in this exercise can be found here.
Uses of dynamic reporting might be:
Reading the...
Read more »
When replying an email which has background color, if you would like to remove it, you can use the following 2 means introduced in this article.
Some users like to use their preferred background color in their emails. Thus it is believed that you may have ever received such emails which contain customized background color. If you dislike the color, you must wish to remove it when reply the email. As usual, to remove the color, you can manually change the “Page Color” to “No Color”. However,...
Read more »
At times, you may wish to batch send an email to all the contacts in a specific domain. In this case, you can use the method introduced in this article to quickly get it.
For some reasons, sometimes, you may need to send an email to all the contacts in a specific domain in your Outlook. For instance, you are required to send an email to all of your colleagues whose email addresses are certainly in a specific email domain. It will be quite troublesome if you manually find out these contacts....
Read more »
