AutomaticCalculation.xlsm

<div>
Thanks for all the input. &nbsp;This will be a one user worksheet and I still don't understand why they would want it but to each their own. They ask and I try to accommodate.
</div>


Thanks for all the input.  This will be a one user worksheet and I still don't understand why they would want it but to each their own. They ask and I try to accommodate.

<div>
ssblue<br />
<br />
While you and I know know that there are possible solutions, sometimes, for the end user, the best answer is: <br />
&quot;no it is not possible&quot; or <br />
&quot;there are several possible solutions; I will need at least x hours to develop and test them; how much time will it save you? is the time I am going to spend worth the saving for the company?&quot; <br />
<br />
Alexandre
</div>


ssblue

While you and I know know that there are possible solutions, sometimes, for the end user, the best answer is:
"no it is not possible" or
"there are several possible solutions; I will need at least x hours to develop and test them; how much time will it save you? is the time I am going to spend worth the saving for the company?"

Alexandre

<div>
<div class="content wysiwyg-content">
I would like to enter 10000 in cell 'D4' and it automatically do a calculation.<br />
<br />
Example: &nbsp;In cell 'D4' enter 10000 and when I hit enter it returns '5' &nbsp;(calculation is 10000 / 2000)<br />
<br />
so, no matter what number I enter in 'D4' it automatically divides it by 2000.<br />
<br />
If this is code &nbsp;where and how do I enter that?
</div>
</div>


I would like to enter 10000 in cell 'D4' and it automatically do a calculation.

Example:  In cell 'D4' enter 10000 and when I hit enter it returns '5'  (calculation is 10000 / 2000)

so, no matter what number I enter in 'D4' it automatically divides it by 2000.

If this is code  where and how do I enter that?

auto calculate in the same cell as you enter value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.