Data Validation List content controlled from cell
In the end I solved the problem myself!
I created a table with labels - each column representing a different
list.
Then with one cell "LIST" used to direct the choise of list I created
an OFFSET statement OFFSET(LIST,0,I10-1,4,1) that I used in the
VALIDATION list box (not forgetting to use an array input
|