And then add the description according to your need.
On the other hand, you can also click the small button on the bottom of the worksheet to replace the above 6 steps. Thus, the “Record Macro” window will pop up.
If you still want to sort this larger range with new data set by the same criteria, you need to perform the process of custom sort again. When you add a new data set into the range, it will not change the rank automatically. The image below shows an example of such a condition. When you add additional data and information into the range, the order in the range will not change automatically. You will sort in a range with certain data and information. However, if you use this feature frequently, you may also find a problem. When you use the custom sort, you will find that this is an amazing feature in Excel.
#EXCEL VBA ON UPDATE HOW TO#
In this article, we will talk about how to automatically update custom sort in a range by using the Excel VBA. The custom sort in Excel is a very useful feature.