Hi Jeff,

This works perfectly, though I need to extend the code across ten columns as there is a DV List in each column and the value "Total" can be selected from any of them. I tried to extend your code to allow this to work for each column, what am I doing wrong? (I've only tried to add the second column below).

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address <> "$H$100" Then Exit Sub
    If Target.Value = "Total" Then
        Range("$H$98").Value = "£'s Thousands"
    Else
        Range("$H$98").ClearContents
    End If
    
    If Target.Address <> "$I$100" Then Exit Sub
    If Target.Value = "Total" Then
        Range("$I$98").Value = "£'s Thousands"
    Else
        Range("$I$98").ClearContents
    End If
End Sub