How To Make the Table Sort Automatically Without using Sort Button?.
For Example, I Changed one of the Cell's Value. Then The Table Sort itself.
How To Make the Table Sort Automatically Without using Sort Button?.
For Example, I Changed one of the Cell's Value. Then The Table Sort itself.
Hi Hanif,
The only way that this can be done is by using a macro that is triggered whenever something new is entered in the worksheet. You can, for instance, add a macro to the code for a worksheet that is triggered when something in the worksheet changes. (You can view the code window by right-clicking the worksheet tab and choosing View Code from the resulting Context menu.) The following is an example of one such simple macro:
The macro assumes that you want to sort on the data in column A and that there is a header in cell A1. If the names are in a different column, just change the cell A2 reference to a different column, such as B2, C2, etc.Please Login or Register to view this content.
Of course, sorting anytime that any change is made can be bothersome. You might want to limit when the sorting is done so that it only occurs when changes are made to a specific portion of your data. The following version of the macro sorts the data only when a change is made in column A.
There are some drawbacks to using a macro to automatically sort your data. First, since you are using a macro to sort, the operation is essentially "final." In other words, after the sorting you can't use Ctrl+Z to undo the operation.Please Login or Register to view this content.
MasS
Thank you so much mail_subrahmanyam :D. I really need this because i want to sort my table automatically without using sort button :D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks