Sort records after entering new data at the end of the list

[adelkam]

My data records starts from Column "B" to column "AD". The table headers at cells "B6" to "AD6", the actual data starts at row 7. I add new records to the table constantly. After I add all the new records at the end of the table, I need to get all data records sorted in ascending order based on Column "B". I think of vba code that fires at "Worksheet_Deactivate" event .. I appreciate your help .. thanks

 

[excelpunk]

I dont know if I understood your requirement completly but all you should do is to sort the table based on column B. Record a macro and then replace your last row with a variable.