But formulas won't change values in other cells. You'd have to use some kind of
macro to do the changes to the other cells.
Personally, I think keeping one cell for input (C8) and using formulas in C18 &
C19 would be more straightforward for the user, too.
I'd even lock those cells with the formulas and protect the worksheet so that
the user can't change C18:C19.
Yvannia wrote:
>
> If i have a cell C18 with list values "25-51-91","25-51-82","25-51-54"
> "25-51-55","25-50-23"
>
> a cell c19 with list values"0", "1", "E"
>
> and cell C8 values "UA 115180-4, UA 115169-1,UA 115169-5, UA 115163-5H,
> 3DF-A35-11D-G"
>
> and when i select C8= UA 115180-4 ,c18 should be "25-51-91" c19 should be 0
>
> when i select UA 115169-1,UA 115169-5, UA 115163-5H c18 shld be
> 25-51-82,25-51-54,25-51-55 cell c19 value should be 1
>
> when i select 3DF-A35-11D-G" c19 should be 25-50-23 c19 value should be E
>
> How can i get it automatically done? so that when i select the value for c8
> then the values for c18 and c19 is auto generated ? or vice versa when i
> select c19, the rest of the 3 are auto changed
>
> Yvannia
>
> --
> Yvannia
--
Dave Peterson
|
Similar Threads
