Excel

R

Richard Dye

How do we obtain help on spreadsheet queries?

We need to know how, if you enter a formula into a cell
which changes the value in another cell how the changed
value can be maintained in the second cell after deleting
the amount entered into the first cell.


Regards


Dickey
 
D

David McRitchie

Hi Richard,
Specifically you want a formula to be used and then you want
that formula to change another cell and then for the formula
to disappear.

A formula cannot change the value in another cell.
Try to explain what you want to do and what you
have in a cell. It is unreasonable to try to answer a
question that is not clear.

The closest I can think of might be an Event macro
that creates a value in column B when a cell in Column A
changes, but does not change the value in column B when
Column A is cleared. With an Event macro you might
have the calculation within the macro. But without a clear question of
*exactly* what you want, I feel that it would be a waste of
time including your to try to answer and not provide a
correct answer.

Also the words "Excel" or "help" or "urgent" for that
matter have very little meaning in an Excel newsgroup.
So effectively you have entered a question without a subject
title. Please try to make the subject match the question,
and make sure that the question is clear.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
G

Gord Dibben

Richard

You can't enter a formula in a cell and affect a second cell unless the second
cell also has a formula pointing to the first cell.

To keep values in a cell that derives its result from another cell, copy the
second cell and(in place) Paste Special>Values>OK.

Gord Dibben XL2002
 
Top