Conditional Auto fill

[naijaexcel]

Can anyone help please. i would like to auto fill a cell based on a
selection in another cell. I tried using an IF formula, but this would
not let me edit the cell after it has been autofilled.

All help is appreciated!




--
naijaexcel

[Debra Dalgleish]

If you use an IF formula, you can type a different value in the cell
later, but that would remove the formula.

Another option is to use programming to fill the cell. There's an
example here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0027 - Update Dependent Cell'

naijaexcel wrote:
> Can anyone help please. i would like to auto fill a cell based on a
> selection in another cell. I tried using an IF formula, but this would
> not let me edit the cell after it has been autofilled.
>
> All help is appreciated!
>
>
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html