Reorder a list after data input

[macca_efc]

Hi,

I am after some help, I want to reorder a list every time a new data entry has been made. I have explained what I am after with this video and attached the spreadsheet.

Loom | Free Screen & Video Recording Software

Use Loom to record quick videos of your screen and cam. Explain anything clearly and easily – and skip the meeting. An essential tool for hybrid workplaces.

www.loom.com

Many thanks in advance.

Andy

 

[maabadi]

Welcome to MrExcel Message Board.
You can use VBA. If your table is in Column A to C and start from A1.
And you want sort it based column C then
1. At excel window on sheet name Right-Click & Select View Code.
2. At window appeared Paste this code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Long, Lr As Long
If Target.Column = 3 Then
Lr = Range("C" & Rows.Count).End(xlUp).Row
Range("A1:C" & Lr).Sort key1:=Range("C2"), order1:=xlAscending, Header:=xlYes
End If
End Sub

3. Close VBA Window and then Save as your file as Macro-Enabled Workbook (.xlsm)
4. Now your file ready. each time you enter Data at column C your table sorted based on.