Hi.
I would like the calculations in column "C" were made in the "B".
I type a value in B2, then B2 will result.
The calculation will be well, when entering a value in any cell in column "B".
will be sought in the spreadsheet "X", the value in column B of this worksheet will be multiplied by a cell in column "A".
See the formula in column "C", to better understand.
I tried this code but it did not work.
[VBA]Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B2:B10")) Is Nothing Then
Exit Sub
Else:
Sheets("Plan1").Range("B2").Value = Sheets("X").Range("B2:B10").Value * Sheets("
Sheets("Plan1").Range("B2").Value = Sheets("X").Range("B2:B10").Value
End If
End Sub
[/VBA]