Place source to drop down list in another spreadsheet
Don't hide the column with the validation list. Set the font color of the
items in that column to the same as the color of the cell. In the column the
list will be invisible, in the dropdown the list will still be visible.
--
Gary''s Student - gsnu200729
|