| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating cells when one is typed into
I have a worksheet that has columns for insurance companies and row for
different codes that we us. The problem is that I need to update several rows in the same column and they are not all seen at the same time because it is a large sheet. I need it to update the other cells no matter which cell is typed into. Here is a small version where you can see that there are 3 sections that contain L1800 and I would like the two others to be updated with the correct value. Some times the first L1800 would be used and some time the 2nd or 3rd would be used. Is this possible? Cigna Benefit planners Medicare L1800 _______ L1620 L1845 L1800 _______ L2830 L2785 L2795 L1800 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells change color when another cell is activated or typed with an | Excel Discussion (Misc queries) | |||
| How can I protect cells w/formulas from being typed over? | Excel Discussion (Misc queries) | |||
| Can numbers be typed to automatically be negative in cells? | New Users to Excel | |||
| How do I apply a formula to #s already typed in a series of cells | Excel Worksheet Functions | |||
| can I turn off the memory carry-over from previously typed cells | Excel Worksheet Functions | |||
Threaded Mode
