Change data in a Table

[Derek McGill]

I am looking for code / tips / links to Update some of the data in a sorted table with new data from K8-K17.

 

[vletm]

Derek McGill
... just edit 'Up dated' and that's it
(It saves previous value and makes timestamp too)

 

[Derek McGill]

Code is good but it cant be used as a Worksheet_Change.

 

[vletm]

Why cannot?
and
Why cannot change it like this?

Sub From8To17()
    Application.ScreenUpdating = False
    For ay = 8 To 17
        Application.ScreenUpdating = False
        l_tab = "List of Players"
        g_tab = "Gradings"
        chk_g = Sheets(l_tab).Cells(ay, 7)
        chk_k = Sheets(l_tab).Cells(ay, 11)
        yg = WorksheetFunction.Match(chk_g, Sheets("Gradings").Range("A:A"), 0)
        With Sheets(g_tab)
            .Cells(yg, 15) = .Cells(yg, 4)
            .Cells(yg, 16) = Now
            .Cells(yg, 4) = chk_k
        End With
    Next ay
    Application.ScreenUpdating = True
End Sub

 

[Derek McGill]

Its a 10 week Chess tournament and the "Data" Table values cant change until contest is over then ratings are updated and used for a new contest.

 

[vletm]

... so You have to run 'my 2nd sample' manually