How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions....
Read more »This exercise shows how to read data from a website, in this case up-to-the-minute currency exchange rates from Yahoo.com. It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel...
Read more »In Excel worksheet, you can also make a lucky draw. In this writing piece, we are going to show you how to finish this task in Excel. A Lucky draw is very common in our daily life. For example, you need to give bonuses to employees in the end of...
Read more »Video is a very common form of media. In this article, we will show you two techniques to embed videos into your Excel worksheet. In many cases you need to use videos to demonstrate some information. At the same time, you may also need to use...
Read more »The Excel security is rather important for your work. In this article, we will introduce the method to set different privileges for different users by Excel VBA. In our previous article How to Create a Login Window to Protect Your Excel Workbook,...
Read more »Pivot table can help us manage large data and information. In this article, we will introduce how to group or ungroup data in a pivot table. There are many useful features in pivot table. And those features make the pivot table a very useful tool...
Read more »The sequence numbers can always be seen in an Excel worksheet. In this article, we will show you how to auto update the sequence numbers when you insert or delete rows in a range. You will certainly have used the sequence numbers in a worksheet....
Read more »Using defined name in Excel can save you a lot of time. Here we will introduce two methods to automatically update the reference range of a defined name in the worksheet. A defined name has a wide range of use. You can even use a certain name in...
Read more »Collecting all the file names in a worksheet is very important to your work. In this article, we will introduce a method to input all the file names into a worksheet by using VBA macro. In our previous article 2 Methods to Copy the List of All...
Read more »The drop-down list in data validation is a frequently used feature in Excel. In this article, we will introduce two methods to auto refresh the drop-down list. In our previous article How to Create Drop-down List from a Range of Cells in Your...
Read more »