daily advisory report.xls | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
4 | Daily$booked | 39,827.75 | 196 | |||
5 | ||||||
6 | 27,866.03 | |||||
7 | 11,941.72 | |||||
8 | ||||||
9 | Monthbooked | 759,593.92 | ||||
10 | ||||||
11 | ||||||
12 | 219,152.47 | |||||
Sheet1 |
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row = 4 And Target.Column = 3 Then
x = Range("c4").Value
y = Range("c9").Value
[c9].Value = x + y
Else: Exit Sub
End If
End Sub