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 »Excel functions can help you a lot in your work. In this article, we will discuss about the difference between the built-in ROUND function and the VBA ROUND function. You will certainly have used the ROUND function in your Excel. If you also use...
Read more »