hi
is it possible to use named ranges for data validation drop down lists
in cells b2:b7 i have colours and i have named them COLOURS
in cells b20:b24 i have names and i have named them NAMES
in cell m4 i want the drop down list to include COLOURS AND NAMES
only im not getting the colours. i should be getting red,yellow, green etc and names the same but in the drop down box im getting NAMES rather than the names that mae that range
when i do it the other way and use source it returns a message saying
you may not use unions,intersections or array constants for data validation criteria
anyone?
Bookmarks