ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

­pºâ«á¦Û°Ê§R°£

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
     If .Count > 1 Or .Item(1) = "" Then Exit Sub
     If Not Intersect(Range("a3:c3"), .Cells) Is Nothing Then
        .Cells(-1, 1) = Val(.Cells(-1, 1)) + Val(.Value)
        .ClearContents
     End If
End With
End Sub

A3:C3 >> A1:C1

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD