CopyCellValues

[Guest]

I have a question that may not be possible to answer.

Cell D1 equals an integer value resulting from a formula.
I have set cell A1 to have the same numerical value. (=D1)
Can set the cell A1 to allow an operator to enter another value into
cell A1 manually as long as it is a numerical value.
But have the cell, A1, after the program is executed continue to
be equal to the value of cell D1.

 

[Frank Kabel]

Hi Mike
you can't have both at the same time in a cell: a formula and a manual
entry. The only way to achieve something similar would be to use VBA /
an event procedure. But maybe you can explain what you're trying to do
with the value in cell A1. There may be better solutions

 

[Guest]

Hi Frank:
Thanks for the response. I believe as you say that a VBA program
would have to be used. My intent was to allow the operator to either
accept the numerical value in cell A1 or enter another numerical value.
But if the operator entered the value in cell A1, it would erase the entered
function in cell A1 such as "=D1". After that entry, the operator would then
manually all the values in call A1, no matter what values were displayed
in cell D1.

I appreciate your help.

 

[Frank Kabel]

Hi Mike
how should the user tell Excel that now A1 should again use the value
from D1 after he had entered a value in cell A1 manually?. Should this
happen if cell D1 changes AFTER the user has entered something manually
in cell A1?

Just as a suggestion to live without VBA.
- use cell A1 with your formula like
=D1
- use A2 for possible manual entries. If A2 is blank, A1 is used in
your further calculatgions

Now you could use for example the following kind of formulas
=IF(A2="","A1 formula","A2 formula")

Depends on the kind of calculations you want to do with this value