How to make a drop down list dependent on another

I have been trying for a time to make a drop down list that depends on another one.

The first drop-down is used to select which category of items the second one will display.
The second drop down will list values from the range selected from the first
See the following link to see what I want to do:

The difference is: each range is listed on a different sheet on the same document.

On Excel the solution is straight forward, but on Calc it does not work like that. How can I implement it?

1 Like

Using range names, nothing change by the data in different sheets, you only need to create the range where their data are.

Find attached a sample file, Dependant Drop Down.

In data validity use Cell range not List.

1 Like