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