Automatically update a file when a cell is changed

[OJSMALL]

Hi, I'm new to all this, I have a spreadsheet where i have to do checks and i was looking to have the item moved to the bottom of the file when completed, I would like this to happen automatically when i update rather than having to run the code again and again,
The cells are G2 - G100 but i cant make it automatically happen ! Can this be done ??

 

[Joe4]

Welcome to the Board!

You can have this run automatically upon a specific cell being updated, as long as it is being updated manually and not by a formula.
So, are you saying that when the value in column G is updated, that whole row should move down to the bottom of the list?

 

[Joe4]

The following code will move a row to the bottom of the sheet when column G is manually updated.

To make sure it runs automatically, you must put it in the proper module. An easy way to ensure this is to go to the sheet you want to apply it to, right-click on the Sheet tab name at the bottom of the screen, select "View Code", and paste this VBA code in the VB Editor that pops up:

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim r As Long

'   Only run if one cell updated at a time
    If Target.CountLarge > 1 Then Exit Sub
    
'   Only run if cell updated is in column G after row 1
    If Target.Row = 1 Or Target.Column <> 7 Then Exit Sub
    
    Application.EnableEvents = False
    
'   Get row number of update
    r = Target.Row
'   Move row to bottom of sheet
    Rows(r).Cut Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
'   Delete blank row
    Rows(r).Delete
    
    Application.EnableEvents = True
    
End Sub

Then, as long as you have VBA/Macros enabled, this code will run automatically when column G is manually updated.