| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Auto fill
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Auto fill
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 he 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill | Setting up and Configuration of Excel | |||
| Conditional color fill whole line... | Excel Worksheet Functions | |||
| Auto fill color change | Excel Discussion (Misc queries) | |||
| Auto fill option box disappeared | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
