right click on the sheet's tab, choose View Code, and paste this codein

Private Sub Worksheet_Change(ByVal Target As Range)
Const strRange = "J13:J30"
Const Multiplier = 1.1

If Intersect(Target, Range(strRange)) Is Nothing Then Exit Sub

Application.EnableEvents = False

If IsNumeric(Target.Value) Then Target.Value = Multiplier * Target.Value

Application.EnableEvents = True

End Sub



"Humph" wrote:

Hello,
I have tried to find how to do this almost everywhere in the excel help,
internet and even questions asked in this group to no evail. Could some one
please help.
I am trying to make a work sheet where say, I put a dollar value in J13 of
$100, I would like it to automatically add 10% in the same field. I will
continue this down to J30, then make J31 Total the whole lot.
Is this possible?
Then is it possible to hyde the formula so my clients don't see the Tax value?
I really appreciate your help.
Humph