View original (French)

Update after changing a multiple choice list

mellberg25 Posted messages 2 Status Member -  
mellberg25 Posted messages 2 Status Member -
Hello forum,

I have a problem that I can't solve...

I have a cell (Sheet1 A1) where I've integrated a multiple choice (list present in Sheet 2 A1:A5). Let's say this list is 1 2 3 4 5

My problem is that, for example, when I choose to fill cell A1 with 3, and then I replace the 3 in the list with a 30, when I go back to Sheet 1, my cell A1 is still filled with a 3 (and not 30).

Basically, when I modify my source list, I want the drop-down cell to update as well.

Thank you for your help.

2 answers

  1.
    Daysorrow Posted messages 12 Status Member
     
    Hello :)

    Maybe I didn't understand your question, but have you tried copying the formatting? (the little paintbrush :p)
    0
  2. mellberg25 Posted messages 2 Status Member
     
    Hello,

    Thank you for your response, unfortunately, it does not solve my problem. I think, however, that you grasped my issue: another example to be clearer:
    Sheet 1 cell A1: multiple choice cell
    the list of these choices is available in Sheet 2 cells B1:B5
    initially the list is: B1=yellow B2=green B3=blue B4=purple B5=red
    so I go to my Sheet 1 and I choose to fill A1 (the multiple-choice cell) with the value "green" so A1=green

    Now I want to change my choice list, so I go to Sheet 2 and give new values the list then becomes: B1=chick yellow B2=apple green B3=sky blue B4=plum purple B5=scarlet red

    So far so good, however, when I go back to Sheet 1, my cell A1 has not changed; it is still filled with the value "green,"
    I therefore want that when I return to my Sheet 1, my cell A1 is changed to apple green.

    Thank you in advance and have a nice day.
    0