Hello, i wanted to create a depended drop down list. I have a problems, it only works in this same sheet, when i want use data from other sheet it is not working…
For first drop down list i used standard: data - validity - cell range and i choose this range:
That works, but when i want also copy data to second, depended drop down list i don’t get a score.
I was able to do it in this same sheet and it was like this:
It worked good but how to rearrange it when that every of cell is in other sheet?
I added sample file (i found it in some forum, it is not mine), when it work on one sheet, i just want to create this drop-down list in second sheet.
I use linux ubuntu, LibreOffice 6