Place source to drop down list in another spreadsheet
What do I do when I wan't to use validation from a list, but I do not want
the list to be visible on the spreadsheet?
If I hide the rows containing the list, the hidden values also becomes
hidden in the list.
And If I link to a source list in another spreadsheet, I get an error.
|