Excel Data Validation List From Another Worksheet. In our sample that is. Web use a named range.
How to create external data validation in another sheet or workbook? from www.extendoffice.com
D and from sheet 2 n18:n and combine both. Web use a named range. Web hi everyone, i am creating lists using data validation in excel 2007 and want to put the list options on a separate sheet to make sure they don't get accidentally.
