Conditional Auto fill

N

naijaexcel

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

All help is appreciated
 
D

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'
 
Top