How to Autosort three columns

[archvanarl]

My current VBA code only auto-sort the table based on columns C and E. The problem is after entering a value on each column, it sort immediately from C to D, and from E to F. So, after pressing the tab, there are some instances that i could replace the data being inputted earlier because it sort out immediately. What I am trying to have is the auto sort function will take effect only after entering the value on the last column within a row. In addition, instead of sorting the table based on two columns, I want to make it three, the columns B, C, and E. So, after entering the last value on column E, it will sort out the table from A to Z (ascending).

Please help me techies. Thank you.

[Phuocam]

Try this:

Please Login or Register  to view this content.

[archvanarl]

PERFECT! Thank you so much.