VBA to auto sort and auto sequential number new rows

[Sheetal123]

Hi

I am looking for a macro that will do the following when entering a new row
Automatically create new serial number
Sort on date and then on time
COUNT formula is not suitable for me because it changes the sequential number when the table sorts the row on date and time