Forum Discussion
Data validation with multiple columns
Hello all I work for a medical centre in australia and do all the ordering, I use an excel spreadsheet to enter all the data but it is very time consuming, I want to use data validation from a dr...
I would like to add to Hans' solution that you need to create a named range for the first column in the Product table, and point the data validation list to that named range. Then it will automatically expand with the Product table when it is NOT in the same sheet as the cells with data validation. See attached.
Thanks, Riny!
