Dropdown menu saved values

[Karlsen97]

Hi All

I was wondering if it is possible to create a drop down menu and have different cells have different values dependent on the drop down selection.

So for example, A1 will have different drop down options like A, B and C. When A is selected the range for like B2:D4 will all be the value of 1-9, and if A1 is selected to be B, then all the values in range B2:D4 are 10-19 and so. The point would be to be able to enter any values in those cells, and that their values are saved whenever changing the value of the A1 cell.

Is something like this possible?

Thank you in advance

[PKG]

As alternative Create Scenario.

Create Scenario.ods (9,7 KB)

[schiavinatto]

Post example file…

[Karlsen97]

Thank you, that was exactly the thing I was looking for and had in mind.

I am however having a little trouble with editing/deleting them once created.

How do I go about editing the name or deleting one if I made a mistake?

It says online I should right click their name, but nothing comes up when doing it.

[PKG]

@Karlsen97

It says online I should right click their name, but nothing comes up when doing it.

[Karlsen97]

Is it possible to reorder the scenarios without having to delete them and make them in the specific order?

[fpy]

@Karlsen97

wondering

there are plenty of ways to do it, but for the basic principles …

@Karlsen97

drop down menu

Data validity > cell range : Criteria

@Karlsen97

selected

MATCH() the reference, like Return Cell address from a lookup result - #7 by karolus

@Karlsen97

then all the values

dereference with INDIRECT()

ask105126 - Dropdown menu saved values.ods (13.1 KB)

You mayt find related ideas in many discussions like Apache OpenOffice Community Forum - [Solved] Validity drop-down with data range choice - (View topic)