| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional cell auto fill
Hi,
I've got a worksheet where a column has a pre-defined set of values(a list). When one of those values is selected, i want to fill other cells within that row with other values. So for example, if in A2, 2 is selected from a drop down list, i want to fill B2 with "NOT REQUIRED" and C2 with "Enter string here", and allow the user to enter the string. I used an IF statement to achieve this , but of course C2 cannot be altered!Any ideas from anyone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| quick ? on how to auto fill text from one cell to another | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Auto fill option | New Users to Excel | |||
| Auto fill multiple cells depending on single cell value | Excel Worksheet Functions | |||
| Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
Linear Mode
