| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data entry for fixed cell ranges
Hi
I have an Excel worksheet with fixed data in cell ranges. Say in C2:C9 and B2:B8 the data is fixed. If I click on any of the cells in this range C2:C9 and I would like “Penicillin = Sensitive” entered into cell A11 and If I click on any of the cells in this range C2:C9 and I would like “Augmentin = Sensitive” entered into cell B12. There are a whole lot of other ranges to work with too but if someone could steer me in a direction I would be able to work the rest out myself Any help is much appreciated. Thanks Eddie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I lock a cell after data entry so entry can not be changed | Excel Discussion (Misc queries) | |||
| How do I force entry in multiple cell ranges in one worksheet | Excel Worksheet Functions | |||
| Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Need formula for a fixed cell minus last entry on ongoing log | Excel Worksheet Functions | |||
Threaded Mode
