automatically divid

  • Thread starter Ali.Abughrabieh
  • Start date
A

Ali.Abughrabieh

How I can make the number been divided automatically in the cell without
adding the divided number or make a formula like =A1/12 .
 
J

Joel

You need to make a worksheet Change macro that when you enter data in certain
cells it will automatically will do the division. Usually you only want this
done in certain columns or certain rows and not the entire worksheet

Sub worksheet_change(ByVal target As Range)

If target.Column = 6 Then
Application.EnableEvents = False
target.Value = target.Value / 6
Application.EnableEvents = True
End If

End Sub

w
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dividing a number up evenly into a year 3
How do I round up numbers when dividing? 2
Formulas 2
Displayed results in a cell 2
Number automatically divided by 100, why? 4
copy formula with same cells involved 3
I don't need the actual value but what is shown 2
how do i set up a profit margin formula 4

Top